Help with using Networkdays as a column formula

hjarriaran

I want to create a column Formula that captures the Start Date and End Date in Networkdays but does not show the Invalid Data Type error for every unused column.

Trying to do this without using dependencies since I want more freedom with the start/end dates to be driven by the status rather than input.

I tried to use IF but can't seem to make it work.

Peggy Parchert

Hello @hjarriaran

Wrap your formula in IFERROR to stop the #INVALID DATA TYPE

=IFERROR(NETWORKDAYS([Start Date]@row, [End Date]@row), "")

Hope this helps

Peggy

KColvin_civic1

I figured it out…. My column type was Duration; silly me wanted the Column Formula to work there…. I had to change it to text/number to work. Now there is no longer a 'd' next to the number of days in the Duration column. It would be nice it it would work.

Peggy Parchert

Hello @hjarriaran

Wrap your formula in IFERROR to stop the #INVALID DATA TYPE

=IFERROR(NETWORKDAYS([Start Date]@row, [End Date]@row), "")

Hope this helps

Peggy

hjarriaran

Thank you! It did.

KColvin_civic1

I got this formula to work but cannot get it to convert to Column Formula.

=IFERROR(NETWORKDAYS([Civic Start Date]@row, [Civic Completion Date]@row), "")

Any suggestions

KColvin_civic1

I figured it out…. My column type was Duration; silly me wanted the Column Formula to work there…. I had to change it to text/number to work. Now there is no longer a 'd' next to the number of days in the Duration column. It would be nice it it would work.

hjarriaran

https://community.smartsheet.com/discussion/comment/480465#Comment_480465

I was out of town but yes! that pesky Duration column will prevent you from converting it to a formula column.

However! after you convert the column into a formula column. You can change the column type back to duration. That will bring back the "d" after the number. 😁

KColvin_civic1

https://community.smartsheet.com/discussion/comment/480698#Comment_480698

Well that's nice (and strange). I appreciate your help!