=netday
Hi,
I'm trying to get =netday to work but I keep getting "invalid data type".
trying to see how many days it takes to review from the starting date to closing date of review
this is the formula =NETDAYS([Tissue Received]@row,[Final Donor Disposition Date]@row
Answers
-
Hello @jivo
Have you verified the properties of the columns "Tissue Received" and "Final Donor Disposition" have the column properties of a date?
Otherwise the formula appears correct:
=NETDAYS([Tissue Received]@row, [Final Donor Disposition Date]@row) -
Try checking the Column Properties for both the columns - Are they both set to "Date" for their Column Type and are they restricted to accept dates only? Are all the values dates in all rows in those columns? I think that error implies that NETDAYS is being given some non-date values, which it can't work with.
-
Hi Mr.Chris, the first column "Tissue Received" is showing me this. "Final donor disposition" is set to date only
-
@jivo they both have to have a property of Date for your formula to work.
The issue is your primary column has a date. You need to create a duplicate column for example:
Create a column named "Tissue Received 2" make sure it has date properties.
Copy and paste the data from the original "Tissue Received" column to "Tissue Received 2"
I would then rename the first "Tissue Received" to something like "Primary Column".
Then remove the "2" from the new column, make sure your formula is updated to the new column. -
thank you so much Chris!
-
Absolutely.
As a precaution I would make sure there aren't any automations being driven from the original primary column. If so re-map those workflows to the new column.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!