I need to calculate the number of working days a task has been assigned, if not closed or canceled


Below is what I have tried but it does not work.

=IF(Status@row = "Closed", ()), IF(Status@row = "Canceled", ()),NETWORKDAYS([Date Assigned]@row, TODAY())

Best Answer

  • Frank S.
    Frank S. ✭✭✭✭✭✭
    Answer ✓

    @SmartSheet Newbie

    No problem, I think this should meet your needs:

    =IFERROR(IF([Actual Completion Date]@row = "", NETWORKDAYS([Date Assigned]@row, TODAY()), IF(OR(Status@row = "Closed", Status@row = "Canceled"), NETWORKDAYS([Date Assigned]@row, [Actual Completion Date]@row), "")), "")

    I added the IFERROR piece in case there are no dates in any of the fields we reference.

    Please let me know if you have any additional questions.

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!