Smartsheet Formula Assistance

Heather Druckenmiller

I am currently using the formula above to calculate days between 2 days, but there is not always going to be a date for the line. So on the lines where there is no date to calculate I want to return a 0 instead of #INVALID DATA TYPE. Can some suggest how I can do this?

MichaelTCA

Hello @Heather Druckenmiller

You can try adding the IFERROR function around what you already have developed.

=IFERROR(NETWORKDAYS([Date Pending NSC]@row,[Completion Date in Customer Solutions]@row),"0")