Update to Is Not Blank Formula?
How do I make this formula operate the way I need to. If there isn't a due date or a status, I don't want it to get flagged as at risk yet.
=IF(OR(Status@row = "Completed", [Due Date]@row = " "), 0, IF(AND(Status@row <> "Completed", [Due Date]@row  TODAY() <= 3, [Due Date]@row  TODAY() >= 0), 1, 0))
Answers

You could try something like this at the start of your nested if formula:
=IF(AND(NOT(ISBLANK([Due Date]@row)), (NOT(ISBLANK(Status@row))), 0, IF(…
Having this at the start, it will ensure that items that do not have a status and also do not have a due date are not flagged.
Your completed formula would look like this adding on what you already had:
=IF(AND(NOT(ISBLANK([Due Date]@row)), (NOT(ISBLANK(Status@row))), 0, IF(OR(Status@row = "Completed", [Due Date]@row = " "), 0, IF(AND(Status@row <> "Completed", [Due Date]@row  TODAY() <= 3, [Due Date]@row  TODAY() >= 0), 1, 0)))
Is this what you were looking for?

I remember now why I had abondoned this effort. The cell is not considered blank if there is a formula in it.

@Jeannie_Biles I'm not sure which fields you have formulas in, but you can also use different qualifiers instead of the isblank function, such as a ISDATE() function for the due date (assuming you have this column formatted for dates) and you could use a OR(NOT(), NOT()), etc. type function for the status field to rule out all possible statuses (assuming there is a limited list of dropdown or possible outcomes for this field).
Hope this helps!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 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
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!