How do I update my function syntax to stop getting the #INVALID DATA TYPE error?
I'm working within a sheet and trying to calculate the number of days between two dates.
Above is a picture of what I'm seeing and my syntax is below.
=NETWORKDAYS([Start Date]@row, [Date Completed]@row)
I've tried to add IFERROR in a couple places and it didn't help with anything unfortunately. My Task Duration is set as a Number/Text. I've also tried setting it to 'Date' to see if that made any difference, but no luck unfortunately.
Any guidance or direction could be greatly appreciated.
Thanks!
Best Answer
-
@Tina Gigioli It looks like your Start Date is not a true date value (the year shows as YYYY, while the other dates are in default Smartsheet format of YY.) Make sure that both date columns you are referencing are set to Date-type and that the values in them are actual date values that Smartsheet recognizes.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
@Tina Gigioli It looks like your Start Date is not a true date value (the year shows as YYYY, while the other dates are in default Smartsheet format of YY.) Make sure that both date columns you are referencing are set to Date-type and that the values in them are actual date values that Smartsheet recognizes.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Hi Jeff!
Just updated the column properties- thank you! All fixed!
~Tina
-
👍️
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 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!