IF Statement with nested OR

Stephanie Tran
Stephanie Tran โœญโœญโœญโœญ

I am trying to write a formula and I am not entirely sure if it is possible. I have 3 columns, Status, Internal only, and Archived. I am trying to write a formula for the status column to mark it Green, Yellow or Red.

If the archived column is blank and the Internal Only column is unchecked, I need it green.

If the archived column is blank and the Internal Only column is checked, I need it yellow.

If the archived column has a date, I need it red.


Is this possible?

Best Answer

ยซ1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!