Days Remaining formula w/ error messages for missing fields
Good Afternoon,
I have a sheet with Start Date , Due Date and Days Remaining Columns. I am to populate the Days Remaining Field using
=[Due Date]@row - TODAY()
I wanted to have a message display in place of the Days Remaining if the Start or Due date are missing. The messages work if I replace the previous formula with
=IF(ISBLANK([Start Date]@row), "Start Date Missing", IF(ISBLANK([Due Date]@row), "Due Date Missing"))
But I can't figure out how to combine the two. I have tried everyway I can think of but all I get a syntax errors.
Thank You
Best Answer
-
Thank you very much. It works perfectly. It's also much cleaner that what I previously had.
Answers
-
OD you mean combine as in if both are missing then the cell would say
Start Date Missing - Due Date Missing
Or only one if only one date is missing
Or the difference when both dates are present?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Sorry for not being clear,
If Start Date or Both Start and Due Dates are missing it should say "Missing Start Date"
If Just Due Date is missing it should say "Missing Due Date"
Otherwise it should show the calculated number of days remaining.
-
Try this...
=IF([Start Date]@row = "", "Start Date Missing", IF([Due Date]@row = "", "Due Date Missing", [Due Date]@row - TODAY()))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you very much. It works perfectly. It's also much cleaner that what I previously had.
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
This is similar to my question. Do you guys know how the formula to subtract today's date from the Due Date column so it will display the remaining days in the Remaining Days column?
I do not have a today's date column as I am thinking this is auto generated since it is a smartsheet. Any advice?
-
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives