# Help with Flag formula

edited 12/09/19

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:

• ✭✭✭✭✭✭

Hi Erika,

Try something like this.

=IF(ISBLANK([Due Date]@row); ""; IF(AND([Due Date]@row < TODAY(); NOT(Status@row = "Complete")); 1; 0))

The same version but with the below changes for your and others convenience.

=IF(ISBLANK([Due Date]@row), "", IF(AND([Due Date]@row < TODAY(), NOT(Status@row = "Complete")), 1, 0))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Thank you! It worked

• ✭✭✭✭✭✭

Excellent!

Happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!