Formula to Change Symbols in Column Depending on Review Status

Options

Hi all! I'm working on adding a formula to a column to populate status symbols in another column. I've attached an image of the sheet for clarity - I would like to display the symbols in the 'Director Approval Status' column, with the original dropdown selections listed in the 'Director Approval' column. Here is the formula I am using:

=IF([Director Approval]@row = "Approved", "Green", IF([Director Approval]@row = "Submitted", "Yellow", IF([Director Approval]@row = "Requires Review", "Red")))

Thank you in advance for your help! 😀

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!