Help! Nested If/AND/OR Formula's

Options

Hi - I am trying to write a nested formula that evaluates multiple criteria to returns a "Yes" or "No"

Basically I need to assess the status of a task, based on values in multiple columns and state "yes" complete or "no" its not complete in the All Reviews Done column.

These are my Column Names

The criteria is in the right side column.

How do I nested =if(and with OR statements?

I've tried lots of combinations

=IF(AND([Primary Review: Done, Need Info, Problem or N/A]@row = "Green", [Back-Up Reviewer]@row = 0), "Yes"), OR(AND([Primary Review: Done, Need Info, Problem or N/A]@row = "Green", [Back-Up Review: Done, Need Info, Problem, N/A]@row = "Green"), "Yes"), OR(AND([Primary Review: Done, Need Info, Problem or N/A]@row = "Green", [Back-Up Review: Done, Need Info, Problem, N/A]@row = "Gray"), "Yes"), IF([Primary Review: Done, Need Info, Problem or N/A]@row = "Gray"), "Yes", "No"))

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!