If Blank and Workday in the same cell?
Hello,
I'd like a Due Date cell to populate based on a date being entered into another Date Completed cell, and add 35 days. That formula works fine: =WORKDAY([Date Completed]44, +35)
The issue I'm running into is that I'd like the Due Date cell in row 51 to stay blank if there isn't a date entered into the Date Completed cell in row 44, instead I get #INVALID DATA TYPE.
I know there is an ISBLANK function that works, and I did try that, but I can't seem to get both functions to work at the same time in the cell. I'm still pretty new to this and I always have struggled a bit with functions/formulas in Excel as well.
I'd love any help I can get.
Best Answer
-
Either should work,
=IFERROR(WORKDAY([Date Completed]44, 35), "")
=IF(ISBLANK([Date Completed]44), "", WORKDAY([Date Completed]44, 35))
Answers
-
Either should work,
=IFERROR(WORKDAY([Date Completed]44, 35), "")
=IF(ISBLANK([Date Completed]44), "", WORKDAY([Date Completed]44, 35))
-
Thank you so much! That worked beautifully!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!