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.

Screen Shot 2022-12-01 at 8.47.51 PM.png

Screen Shot 2022-12-01 at 8.49.13 PM.png

First time working with this type of formula - Any ideas? I'm all ears :)

Find more posts tagged with

Accepted answers

Genevieve P.

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

All comments

Jason Nairnsey

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/2480316-available-symbols-in-symbols-column

Genevieve P.

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

mweeeee

Hi there, thanks very much! works!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.