duration between each status change

Question

I have a field called status. It has 3 values: Not started, in progress, complete. I'm trying to measure the duration between each status. Is there a simple way to do this?

------------------------------
Laura Carruthers
------------------------------

MarkShnierYou · Answer

Because your use case is very simple, then there may be a way to easily do this. I would suggest setting up an automation to populate a field called [Date Started] with the value in a formula date /time field you will create called called [Current date time] which has a formula of

Now()

When the Status changes to "In Progress".

Similarly similarly fire another automation to populate a different date time field when the status changes to complete.

Then you can subtract those two fields to get the duration.

We will have to decide what to do about the messy situation if a user change the status from complete back to an earlier status.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community