IF-OR-AND Formula for Multiple Scenarios


Help! I need to finalize a formula to return a value of "Yes" if one of two AND statements are true. I am not getting an error with the formula below, but it is not returning a value of Yes or No:

=IF(OR(AND([Send to Compliance?]@row = 1, [Finance Approval Status]@row = "Approved", (AND([Send to Compliance?]@row = 0, [Finance Approval Status]@row = "Approved")), "Yes", "No")))


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!