Nested IF(OR statements column formula

Hello smartsheet Community!

I'm trying to have a status column update based on three approval columns. There's several reasons why a row would be green ("Yes"), yellow ("Hold"), or red ("No"), so I'm trying to use nested IF(OR statements. It's possible I'm overcomplicating this and there's an easier way, any help is greatly appreciated!!


=IF(OR([A Approval Decision]@row = "Approved ",

[B Approval Decision]@row = "Approved ",

[A Approval Decision]@row = "Approved by

Email", [Review]@row = "Duplicate,

Approved"), "Yes", IF(OR([A Approval Decision]@row = "Declined",

IF([B Approval Decision]@row = "Declined",

IF([Review]@row = "Declined"), "No", IF(OR([A Approval Decision]@row = "Submitted",

"Hold", IF([Bs Approval Decision]@row = "Submitted ",

"Hold", IF([Review]@row =

"Submitted", "Hold", IF([Review]@row = "New"),

"Hold")))))))))

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!