RYGB symbols automated to reflect status/progress

JWattz
JWattz ✭✭
edited 12/09/19 in Formulas and Functions

Hi there, Attempting to write formula to automate RYGB symbols when task is In Progress, On Hold or Complete. I've prepared a few formulas and none seem to be accurate. If someone would take a look at below attempts and let me know what needs to be changed, I'd greatly appreciate it!

None of below worked:

=IF(OR([Status]6 = In Progress, ”Blue”,

IF ([Status]6 = On Hold, ”Yellow”,

If ([Status]6 = Complete, ”Green”)))

 

=IF([Status]6 = In Progress, ”Blue”,

IF ([Status]6 = On Hold, ”Yellow”,

If ([Status]6 = Complete, ”Green”)))

 

=IF(Status6 = In Progress, ”Blue”,

IF ([Status]6 = On Hold, ”Yellow”,

If ([Status]6 = Complete, ”Green”)))

Then, attempting using numbers rather than text:

=IF ([Status Numeric]6 = 2, ”Blue”,

IF ([Status Numeric]6 = 3, ”Yellow”,

If ([Status Numeric]6 = 4, ”Green”)))

Thanks!

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!