Help with Flag formula

edited 12/09/19 in Formulas and Functions

I've tried a few different formulas using IF and ISBLANK but can't seem to figure this out, even after looking at a few post on here. Hoping you can help.


I need help with creating a formula for the following:

If a task is incomplete and the due date is in the past, a red flag will appear BUT if the 'due date' cell is blank, I do not want a red flag to appear.


My formula for the first part works: =IF(AND([Due Date]@row< TODAY(), NOT(Status@row = "Complete")), 1, 0)


I just cant figure out the no flag if no due date part. 







Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!