Networkdays Error - Dates used in cross sheet references

I get an #INVALID DATA TYPE error for this formula: =NETWORKDAYS([Baseline Finish]@row, [Planned Finish]@row).

The Baseline Finish and Planned Finish date columns pull these dates from a different sheet using cross-sheet links.

Any suggestions?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Try clicking on the button to remove all formatting and double check conditional formatting rules to make sure it is not left aligned due to that.


    You can also insert a temporary flag column and use a column formula such as

    =IF(NOT(ISDATE([Date Column]@row)), 1)


    This will flag any row that does not contain a date value. If you have a lot of rows in your sheet, you can create a temporary filter to show only those rows that are flagged.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!