Exclude blank "Due Date" cells from formula
I'm trying to update my "At Risk" column (Flag icon ON/OFF). I want to create a nested formula. I want the flag ON if all three conditions are met:
 The "Due Date" is within one day. Example: if today is 20180504 and the "Due Date" is 20180503, then this condition is met.
 I have a "Status" column. If one of these values is met, then this condition is met:
 Terminated
 Complete
 On Hold
 The "Due Date" column needs to have a date value. If the "Due Date" is blank, then I do NOT want this condition to be met.
 This is where I'm STUCK.
 For example, some parts of the project are not well defined or will happen far, far into the future. We don't even know when the due date is, so we'd rather keep the cell blank. I do NOT want the "At Risk" flag to turn on because of a task with no due date.
Here is the start of my formula. Can someone please help me add condition #3 to my existing formula?
=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+
=IF(AND([Due Date]1 <= TODAY() + 1, Status1 <> "Complete", Status1 <> "Terminated", Status1 <> "On Hold"), 1, 0)
=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+
Comments

Michael,
I would write your formula the following way assuming that "Due Date" has been set to the Date column type:
=IF(SUM(IF([Due Date]1 <= TODAY() + 1, 1, 0), IF(OR([Status]1 = "Complete", [Status1] = "Terminated", [Status]1 = "On Hold"), 1, 0), IF(ISDATE([Due Date]1), 1, 0) <> 0, 1,0)
Try that out and see if it works.

I can confirm that my "Due Date" column has been set to the Date column type. However, I'm getting #UNPARSEABLE when I use this formula. I simply copied and pasted this formula in Row 1, but I got the error. What could the issue be?
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 348 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!