How to use All 4 Formulas together "IF AND NOT OR "

Mohammed Sulaiman
Mohammed Sulaiman ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I have to create a formula that returns a value "1 or 0", so I use the IF statement. Now to satisfy multiple conditions, I am using the AND statement. 

Also, to I want to check if the statement is not true, Hence I use the NOT function. 

Based on this, the formula for my example is: 

=IF(AND([Actual Complete]6 < TODAY(), NOT(Status6 = "Complete")), 1, 0)

Now I want to modify my formula such that : 

The status could be either "Complete" or "Completed Late", how do I change the formula. 






Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!