=netday

jivo

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

=Chris Palmer

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)

Courtney S.

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.
https://help.smartsheet.com/articles/2476176-formula-error-messages#toc--invalid-data-type

jivo

Hi Mr.Chris, the first column "Tissue Received" is showing me this. "Final donor disposition" is set to date only

=Chris Palmer

https://community.smartsheet.com/discussion/comment/435143#Comment_435143

@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.

jivo

thank you so much Chris!

=Chris Palmer

https://community.smartsheet.com/discussion/comment/435238#Comment_435238

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.