Formula to Change Symbols in Column Depending on Review Status

emkruczek

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! 😀

Carson Penticuff

Your formula seems fine to me, is it not working?