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

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".

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!