Formula to Change Symbols in Column Depending on Review Status
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! 😀
Help Article Resources
Check out the Formula Handbook template!