How can I create a NETWORKDAYS formula that results in a blank field until an End Date is specified?

I need a column to show =NETWORKDAYS(([Start Date]@row), ([End Date]@row)), but currently the rows where End Date is blank are returning #INVALID DATA TYPE in my formula field.

I would like it remain blank until an End Date value is entered.

=IF(NOT(ISBLANK([End Date]@row)), "Not Blank", "") returns the expected result.

=IF(NOT(ISBLANK([End Date]@row)), NETWORKDAYS(([Start Date]@row), ([End Date]@row)), "") returns a column formula syntax error.

Can anyone tell me what I'm doing wrong?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!