Using If formula with symbols
Hi there,
Trying to create a formula using symbols, but am getting the #UNPARSEABLE message.
Under my Progress column, I'm using symbols (Red, Green, Yellow and Blue).
For the Value if true: if the symbol is green, then I want the number that is entered into the column titled "Run Time" to be populated into "Column 12". For example, if a "5" is entered in Run Time and the symbol is green, I want the 5 to be populated in Column 12.
For the Value if false: if the symbol is any other colour, then I want the number entered into "column 12" to be zero.
This is the formula I've put in but it doesn't seem to be working:
=IF([Progress]4 = 3, "=([Run Time (in Hours)]@row)", "0"))
I'm pretty sure that the 3 should correspond with the green symbol.
First time working with this type of formula  Any ideas? I'm all ears :)
Best Answer

Hiya! 🙂
Just jumping in to clarify here  @Jason Nairnsey is correct! You'll need to spell out the colours as text in your formula and that article will identify the correct text syntax.
However I also wanted to call out the second half of your formula where I see you have a number of quotes:
=IF([Progress]4 = 3, "=([Run Time (in Hours)]@row)", "0"))
Since you're referencing a cell and then a number, neither of these elements need quotes. Try something like this:
=IF([Progress]@row = "Green", [Run Time (in Hours)]@row, 0)
Cheers,
Genevieve
Answers

I think you need to use the actual words, rather than convert to numbers, ie "Red", "Green", "Yellow" and "Blue". See this article for more details:
https://help.smartsheet.com/articles/2480316availablesymbolsinsymbolscolumn

Hiya! 🙂
Just jumping in to clarify here  @Jason Nairnsey is correct! You'll need to spell out the colours as text in your formula and that article will identify the correct text syntax.
However I also wanted to call out the second half of your formula where I see you have a number of quotes:
=IF([Progress]4 = 3, "=([Run Time (in Hours)]@row)", "0"))
Since you're referencing a cell and then a number, neither of these elements need quotes. Try something like this:
=IF([Progress]@row = "Green", [Run Time (in Hours)]@row, 0)
Cheers,
Genevieve

Hi there, thanks very much! works!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!