Using a Risk flag


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)


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!