IF STATEMENT WITH A RESULT IN SYMBOL

Laura Melendez

Hi im trying to archive that is this statement =IF(Price1>Price2,"Green Arrow")

but not sure how to add the green arrow of the symbols is there a way?

Ryan Nix

Hi Lauara,

This took me a hot moment too - here's a link to the available symbols and what you'd put in the =IF statement: https://help.smartsheet.com/articles/2480316-available-symbols-in-symbols-column

So your formula would be =IF(Price1>Price2, "Up") depending on which type of symbol you're using.

Paul Newcome

Another quick way to see what text value needs to be used to generate the symbol is by looking at one of the cells in the Symbol column. It should have a dropdown arrow on the right of the cell. If you click on that dropdown arrow, it will show what options can be selected and includes the text values for each.

Ryan Nix

Hi Lauara,

This took me a hot moment too - here's a link to the available symbols and what you'd put in the =IF statement: https://help.smartsheet.com/articles/2480316-available-symbols-in-symbols-column

So your formula would be =IF(Price1>Price2, "Up") depending on which type of symbol you're using.

Paul Newcome

Another quick way to see what text value needs to be used to generate the symbol is by looking at one of the cells in the Symbol column. It should have a dropdown arrow on the right of the cell. If you click on that dropdown arrow, it will show what options can be selected and includes the text values for each.

Laura Melendez

thanks!

Andrée Starå

Hi Laura,

@Laura Melendez

One method i use sometimes is to use a formula and reference the symbol and then it shows the text for it.

Something like.

=Symbol@row

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Happy to help! 👍️

KarinaG

Hello, I am trying to add the color gray to my drop down... not sure how to use the formula listed above for this. Help would be really appreciated since it's a time sensitive ask.

Andrée Starå

Hi @KarinaG

I hope you're well and safe!

Have you selected the Symbol option, including the Gray option?

I hope that helps!

Be safe, and have a fantastic week!

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!