Using a Risk flag

Options

I want the flag if the date is past due, but it's also giving me a flag if the end date is blank. what am I missing here? I tried to add another NOT statement and ISBLANK, but then was just getting errors.


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

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!