How to auto-populate a status column?

Andrew Ryback

Hi everyone,

I'm looking to create a formula that will auto-populate a status.

If column A equals "YES", then the status is green.

If column A equals "NO", then the status is red.

If column A equals "PENDING", then the status is orange.

Can anyone offer assistance?

Thank you!

SmartWay360

Hi,

There is IF function you can use for this: IF Function | Smartsheet Learning Center

You can use something like this:

=IF([A]@row = "YES", "GREEN", IF([A]@row = "NO", "RED", IF([A]@row = "PENDING", "ORANGE", "NO STATUS")))

Hope this will help.

Best,

Beata

Andrew Ryback

Thank you! That works, but is there a way to get this to populate symbols instead of text? (I'm realizing now I was unclear in my original post).

So instead of spitting back text that reads "green", the status column shows the green circle symbol.

SmartWay360

Hi,

If the column format is set up as symbol it should work without need to change anything.

Below is the list of symbols examples that could be used in the formulas:

• Star, flag, and checkbox symbols: For these symbols, use 1 for on or 0 for off
  • Example: = IF([Status]@row = "Complete",1,0)
• Red, yellow, and green light symbols: Use the literal values Red, Yellow, or Green
  • Example: =IF([Status]@row = "At Risk", “Red”, "Green")
• Priority symbols: Use High or Low
  • Example: =IF([Status]@row = "Overdue", "High", "Low")
• Harvey Balls: Use Quarter, Half, Three Quarter, Full, or Empty
  • Example: =IF([% Complete]@row = 1, "Full", "Empty")

Best,

Beata

Andrée Starå

Hi @Andrew Ryback

I hope you're well and safe!

Here's an excellent help article with an overview.

https://help.smartsheet.com/articles/2480316-available-symbols-in-symbols-column

I hope that helps!

Be safe, and have a fantastic weekend!

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!