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.
Help Article Resources
Check out the Formula Handbook template!