Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

470 1
Showing results for 
Search instead for 
Did you mean: 

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”