Return Red Amber Green

Mad ✭✭
edited 05/19/22 in Formulas and Functions

Hi All,

I wish to return a single rag status from two columns. The two Columns will display "Yes" or No individually.

If both columns are "Yes" I wish to return Green

If one column is "Yes" and the other "No (or vice versa) I wish to return Amber

If both columns are "No" I wish to return Red

I am not sure which function I should be using (IF, IF AND) and how to write the syntax

I appreciate any help as I am a novice and thank you in advance

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!