Formula Support


I am trying to add a formula that will update my "Current Status" with the associated Color Ball based on the "Schedule Status" column.

I have the below formula that is working. However, it does NOT account for multiple options. As I have four different color balls and five "Schedule State" options to coordinate.

Current Formula that is working for single option

=IF([Schedule State]@row = "Accepted", "Blue")

Please help.

If anyone is available to meet for 5-10 min to trouble shoot this, I would be extremely grateful.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!