Basic NETDAYS Help!
Disclaimer: I'm a SmartSheet beginner, and only at an amateur level with Excel formulas.
I've reviewed quite a few NETDAYS posts on here already and tried variations of the solutions in all, but so far every NETDAYS variation I've tried has returned the #UNPARSEABLE error.
I'm trying to write a formula that will calculate the # of days from "Date Submitted" column to "Date Closed" column, and if the "Date Closed" cell is blank, to calculate to Today's Date instead.
=NETDAYS([Date Submitted]@row, [Date Closed]@row)
=IFERROR(NETDAYS([Date Submitted]@row, IF(ISDATE([Date Closed]@row, [Date Closed]@row, TODAY())), 0)
Does anyone have suggestions for how to modify the formula to get rid of the #UNPARSEABLE errors?
Thank you so much in advance!
Best Answer
-
@LDenton okay, looks like you just have some parenthesis in the wrong place. Try this
=IFERROR(NETDAYS([Date Submitted]@row, IF(ISDATE([Date Closed]@row), [Date Closed]@row, TODAY())), 0)
also keep in mind that the today formula will only work if you open and save the sheet. Refer to this help article if you need it to update every day without opening the sheet.
Automatically update the TODAY function in formulas | Smartsheet Learning Center
Answers
-
@LDenton "Data submitted" is actually a date column right? Kind of looks like your primary column.
-
Hi Samuel!
Yes, "Date Submitted" is a date-formatted column. My primary column for this sheet is separate.
-
@LDenton okay, looks like you just have some parenthesis in the wrong place. Try this
=IFERROR(NETDAYS([Date Submitted]@row, IF(ISDATE([Date Closed]@row), [Date Closed]@row, TODAY())), 0)
also keep in mind that the today formula will only work if you open and save the sheet. Refer to this help article if you need it to update every day without opening the sheet.
Automatically update the TODAY function in formulas | Smartsheet Learning Center
-
Thank you so much Samuel, your suggestion worked like a charm! I really appreciate your help!
-
Happy to help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 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!
