How to track the time when the status of a record (or cell) was change?

1088 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi, i need your help

I’m in the middle of a project and I need to track when the status of each record was modify in order to track the time between phases. I have a column in which i track the status of each sub-project (Received, Processing, Ready) and i will like to analyze the average time is taking me on each of the phases.

In the activity panel of each sub-project, i can see how many day ago was change each category, is there any way to transform that data to several independent cells?

For example:
Column 1 → Status Change to Received: 02/10/2021 10:30am
Column 2 ->Status Change to Processing: 02/10/2021 10:40am
Column 3 ->Status Change to Ready: 02/11/2021 9:00am

With this data i will be able to see how efficient i am at my work and will allow me to improve

Many thanks for your help

1 Reply 1
  • Add a Last Modified Time field which only tracks the {Status} field
  • Set an Automation to run “when a record matches certain conditions”, where the condition is {Status} == “Received” and include an Update Record step to fill in {Column 1} with the value from the Last Modified Time field.
  • Create similar automations for “Processing” and “Ready”