How to add an and/or statement into a sheet formula

MKuhns
MKuhns โœญโœญ

I'm a total noob when it comes to formulas and I was hoping someone could assist me with figuring out how to add an "and/or" portion into this formula:

=IF(AND([End Date]3 < TODAY(), NOT(Status3 = "Complete")), 1, 0)

Within the "Complete" portion I would like an "and/or" statement for "Cancelled". So that the "At Risk" column will not be flagged if the date isn't past due, or if the "Status" column is "Complete" or "Cancelled".

image.png image.png image.png

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!