Text to Traffic Light symbols

I am trying to turn text in a status column i have shuttled over using data shuttle from Excel into Smartsheet into a traffic light symbol. My column is Called Status, and the text in the column is green, yellow, red. I thought if i changed the column type smartsheet would identify this and convert to a traffic light symbol, but alas not!

I am using this formula, which works if i just have one result, but not when adding in the other variables. I get unpassable. PLEASE HELP

=IF(Status@row = "Green", "Green". IF(Status@row = "yellow", "Yellow", IF(status@row = "red", "Red")))

Find more posts tagged with

Formulas

Accepted answers

All comments

Andrée Starå

Hi @BecBlah

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

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!

BecBlah

I figured it out, You need to have the data coming through capitalized for smartsheet to recognise the trafffic light colour. they were all lower case in the original import, so had to update my source data.

Andrée Starå

@BecBlah

Excellent!

Happy that you figured it out!

That was the first thing I looked for, which looked correct at first glance.

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Kaveri Vipat

Hi BecBlah,

There is one comma added in your formula =IF(Status@row = "Green", "Green". , so it is showing the error, you can try the below formula.

=IF(Status@row = "Green", "Green", IF(Status@row = "yellow", "Yellow", IF(Status@row = "red", "Red")))

I hope this works for you!

Have a Good Day!

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.