Want to Calculate the Number of days a task is in OPEN status

Options

When the status changes from Open to In-progress the calculation gets reset to 0 days, Please Guide Thanks!

Tags:

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    edited 11/17/21 Answer ✓
    Options

    Hi @SOC Compliance

    How are you currently doing your calculations?

    It sounds like you could set up two helper Date columns in your sheet:

    • One column will automatically record the Date that a row's status changes to "Open"
    • A second column will automatically record the Date when the status changes to any other Status

    See: Set the Current Date with Record a Date Action

    Then you can set up a formula to count the days between those two date stamps. Let me know if this will work for you!

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers

  • Genevieve P.
    Genevieve P. Employee
    edited 11/17/21 Answer ✓
    Options

    Hi @SOC Compliance

    How are you currently doing your calculations?

    It sounds like you could set up two helper Date columns in your sheet:

    • One column will automatically record the Date that a row's status changes to "Open"
    • A second column will automatically record the Date when the status changes to any other Status

    See: Set the Current Date with Record a Date Action

    Then you can set up a formula to count the days between those two date stamps. Let me know if this will work for you!

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!