NETWORKDAYS

Options

Hi!

I am trying to figure out how to calculate workdays a project is taking. I can do it if I have a start date and end date, but if the end date hasn't populated yet I would like to know how many days it has been so far. You will see the first 3 work fine but I want a formula that will do this and if there is no end date calculate how many days it has been going on. See below

Formula Used: =NETWORKDAY([Date Received]@row, [Agreements Received]@row)


Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Trisha

    I hope you're well and safe!

    Try something like this.

    =IFERROR(IF([Agreements Received]@row = "", NETWORKDAY([Date Received]@row, TODAY()), NETWORKDAY([Date Received]@row, [Agreements Received]@row)), "")

    Did that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Answers

  • Ipshita
    Ipshita ✭✭✭✭✭✭
    Options

    Hi @Trisha ,

    Here is the help for you -

    =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

    Ipshita Mukherjee

  • Trisha
    Trisha ✭✭
    Options

    Thank you! It removed the error but I would like it to populate how many days it has been out if possible until the date is filled in.

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Trisha

    I hope you're well and safe!

    Try something like this.

    =IFERROR(IF([Agreements Received]@row = "", NETWORKDAY([Date Received]@row, TODAY()), NETWORKDAY([Date Received]@row, [Agreements Received]@row)), "")

    Did that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Trisha
    Trisha ✭✭
    Options

    Yes! Thank you so much and have a great weekend!

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    @Trisha

    Excellent!

    You're more than welcome!

    Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Kathy PPT
    Kathy PPT ✭✭✭
    edited 03/13/24
    Options

    Hi @Andrée Starå,

    I tried using your last suggested formula above and am getting #unparseable. Hoping you can help, please.

    I'm trying to determine the # of days into the project based on today's date and the onboarding start date (when the project actually started) and target end date (when we committed to have the project done). I've changed the order of the fields referenced in all ways but still get same error.

    =IFERROR(IF([Target End Date]@row = "", NETWORKDAY([Onboarding Start Date]@row, TODAY()), NETWORKDAY([Target End Date]@row, [Onboarding Start Date]@row)), "")


    Thank you,

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!