Ignoring the empty fields
I could use some help with what I'm sure is very simple formula, but ya gotta start somewhere, right?
I want to trigger a Red Flag if the Due Date is Today or later.
This formula does the trick other than it immediately triggers a flag for all empty column fields.
=IF(TODAY() > [Due Date]6, 1, 0)
I know there is an =IF(ISBLANK([DUE DATE]) piece I'm sure needs to be involved I just know the syntax well enough... yet.
Or if there is a better formula to achieve this I'm all ears, or eyes as the case may be.
Any and all help appreciated.
Best Answer
-
You're more than welcome!
Happy to help!
✅Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hi,
Try something like this.
=IF(ISBLANK([Due Date]@row); ""; IF([Due Date]@row <= TODAY(); 1))
The same version but with the below changes for your and others convenience.
=IF(ISBLANK([Due Date]@row), "", IF([Due Date]@row <= TODAY(), 1))
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma."
Did it work?
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
You are truly a scholar and a gentleman - Thank you so much. Worked like a charm.
Yours,
Tony
-
You're more than welcome!
Happy to help!
✅Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | 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
Categories
Check out the Formula Handbook template!