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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking 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 Newcome Trying 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 a new 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 of when it should appear.

Cheers,

Genevieve

CAS the CSA

I have formulas that successfully result in "yes", "hold", or "no", but the symbol column is just displaying text, and not the symbols. Please advise.

* yes the symbols selected are yes/hold/no

** if I delete a formula and type "yes", "hold", or "no" in the cell it displays the appropriate symbol

*** even if the formula is as basic as ="yes" the symbol does not display

Genevieve P.

Hey @CAS the CSA

Symbols are case-sensitive, so your "yes", "hold", and "no" would need to start with capitals:

My top cell is:

="Yes"

My second cell is:

="yes"

Let me know if this now works for you!

Cheers,

Genevieve

CAS the CSA

https://community.smartsheet.com/discussion/comment/414277#Comment_414277

That's too simple! Thank you!

Claire

NeilKY

Also, if you ever want to know what the value needs to be for a specific symbol, just reference the symbol cell from another text field, like =[symbol col]@row. Then change the symbol to the one you want and the value will appear in your formula field.