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?
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