IF formula return RYG symbol based on Status

Donna Newton

Hello - I am very new to Smartsheet and am trying to write what I think is a simple formula, but I keep getting an Incorrect Argument error. This is what I need:

If Status = In progress, green ball

If Status = On Hold, red ball

If Status = Complete, grey ball

If Status = Not Started, yellow ball

David Joyeuse

Hi @Donna Newton

That should be something like:

=IF([Status]@row = "In Progress", "Green", IF([Status]@row = "On Hold", "Red", IF([Status]@row = "Complete", "Grey", "Yellow")))

Hope it helped!

David Joyeuse

Hi @Donna Newton

That should be something like:

=IF([Status]@row = "In Progress", "Green", IF([Status]@row = "On Hold", "Red", IF([Status]@row = "Complete", "Grey", "Yellow")))

Hope it helped!

Donna Newton

Hi @David Joyeuse That was exactly what I needed - I just had to change "grey" to "gray" and it worked perfectly. Thank you!!!

Donna Newton

Follow up comment - What I was doing wrong was trying to write an IF to return the Yellow, instead of leaving the Yellow as the item to return if the first three weren't selected. Light bulb moment!