Hiding #INVALID DATA TYPE with formulas using NETWORKDAYS

afelo

Hello, I'd love some feedback and advice on how to get this to work.

I have Start Date, Due Date, Duration and Due in Days columns.

For my Due in Days column I am using this formula:

=NETWORKDAYS(TODAY(), [Actual Due Date]@row)

For my Duration column I am using this formula:

=NETWORKDAYS([Actual Start Date]@row, [Actual Due Date]@row)

My question: How do I hide the error message "#INVALID DATA TYPE" when using the above formulas? Sometimes I have blank cells in the Start Date and Due Date columns so I need to hide the error message.

I'm very new to Smartsheet so if you could provide a full breakdown or formula to plug in using my above formulas I would highly appreciate it.

Thank you!

SPIPMO

check the closing brackets position @afelo

Ipshita

Hi @afelo ,

You just need to wrap your formula with the IFERROR statement, like -

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

This would return blank where either your start date or due date are blank cells. Hope this helps!

Cheers :)

Ipshita

afelo

Hello Ipshita,

Unfortunately that didn't work. It says #INCORRECT ARGUMENT SET

Any other suggestions?

SPIPMO

check the closing brackets position @afelo

afelo

I was going to comment and say it doesn't work because I tried that yesterday, but I figured I'd give it another shot and it worked! thank you :)