NETWORKDAYS Invalid

Why would this show as INVALID? I enter a NETWORKDAYS formula that highlights with the VALID colors instead of staying grey but then once I hit enter, it does not calculate the NETWORKDAYS? Smartsheet highlights the cells I want it to calculate from correctly. I am at a loss on why this is not working.

Answers

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭

    @HeidiB,

    Have you defined your network days? Right click on any column header and select "Project Settings". The following window will appear.

    Then click "Edit" under "Working Days" and define which days are working as well as enter the dates for the holidays your company recognizes so they can be taken into consideration.

    Hope that helps!

    BRgds,
    -Ray

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!