Help with Flag formula

Options
erika14
erika14
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. 

 

Thanks!

 

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!