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

SOC Compliance

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

Genevieve P.

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

Genevieve P.

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