How can I change this Formula to leave the cell blank rather than #INVALID DATE?
Most of the other columns in my sheet only require the counting of days from a date in a different column. When the source column in the formula is not filled out the cell is blank. I am guessing it has something to do with it starting as "IFERROR".
EXAMPLE OF A FORMULA THAT WORKS:
=IFERROR(WORKDAY([Bldg Initial Submittal]@row, +5, Holidays:Holidays), "")
I have since needed to have a date calculated by adding multiple different values together rather than just counting from a singular date. This formula works when each of those columns have values entered, but when one is blank the Column it is applied to says "INVALID DATE" since it is missing part of the equation.
EXAMPLE OF THE FORMULA PRODUCING #INVALID ERROR:
=WORKDAY([Bldg Initial Submittal]@row, VALUE([Bldg Initial Review Timeframe]@row), Holidays:Holidays)
How can I edit the above formula to leave a cell blank when information is missing?
P.S I have tried doing and got an error:
=IFERROR(WORKDAY([Bldg Initial Submittal]@row, VALUE([Bldg Initial Review Timeframe]@row), Holidays:Holidays), "")
Best Answer
-
Hello,
Something like this perhaps?
=IFERROR(WORKDAY([Bldg Initial Submittal]@row, VALUE([Bldg Initial Review Timeframe]@row), Holidays:Holidays),"")
Answers
-
Hello,
Something like this perhaps?
=IFERROR(WORKDAY([Bldg Initial Submittal]@row, VALUE([Bldg Initial Review Timeframe]@row), Holidays:Holidays),"")
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