Working with Symbol Formulas

Elaine Kershaw

I am trying to do a formula to populate a date based on a symbol. So for instance if the star is empty, take Date 1 and add two years =date+730, but if the star is checked on, add 365.

How do I go about doing this?

Mike Wilday

=IF([Insert star column name]@row = 1, [date column name]@row+365, [date column name]@row +730

Sabrina Beck

I'd like to have a red flag appear in the [PO Here Flag] column when the [Quote Type] is PO Here.

I've never programmed before...thought this is a good time to start learning...

Andrée Starå

Hi@Sabrina Beck

I hope you're well and safe!

Try something like this.

=IF([Quote Type]@row = "PO Here", 1)

Did that work/help?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

✅了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

P Challen

@Paul NewcomeTrying to count number of projects on hold at a certain stage. I have the count by stage but keep getting errors when trying to add that the column must be flagged as "on hold". Any ideas?

P Challen

I found a work around, probably not the best way but it produced the result I was looking for. I created a new column on the source sheet to count the symbol and then used the following formula to count the ref sheet.

melissamedina1

Question, this is a really good thread however, how do you create the header level progress bar abd % complete for that matter?

Genevieve P.

Hi@melissamedina1

I'm sure the Community would be happy to help you if we had more information! I'd suggest posting this as anew Question in the "Formulas and Functions"are of the Community, including screen captures of your sheet and a detailed list of exactly what you want to appear and the criteria ofwhenit should appear.

Cheers,

Genevieve