=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)https://www.linkedin.com/in/zchrispalmer/
-
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.https://www.linkedin.com/in/zchrispalmer/
-
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.https://www.linkedin.com/in/zchrispalmer/
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!