NOT "Complete" or "Not Applicable"

Options

Hi,

How would this be written to say NOT COMPLETE or Not Applicable?


=IF(AND([End Date]8 < TODAY(), NOT(Status8 = "Complete","Not Applicable"), 1, 0)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!