Days in progress formula with multiple criteria


is it possible to run a formula that gets me the following? 

If the status is “Not started” or “in progress” then count the number of business days between “date presented” and today, and if the status is “complete” then Count the number of business days between “date presented” and “date completed”



  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Here's one way to do it:

    =IFERROR(NETWORKDAYS([Date Presented]@row, IF(OR(Status@row = "Not Started", Status@row = "In Progress"), TODAY(), IF(Status@row = "Complete", [Date Completed]@row, "status unknown"))), "date missing")

    This will return "status unknown" if there are other Status values found and "date missing" if there is a needed date not found.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!