Forum Discussion
How to track time in a certain status?
Hello, I've been looking all over for a solution on how to get the average amount of days a list item stays in a status of Awaiting SC. I have a flow set up already which waits for changes to the status column and if it changes to Awaiting SC, then it records the date in a column called Time_in.
Here it is:
The formula I have in Time_in is: formatDateTime(utcNow(), 'MM-dd-yyyy')
The problem is I don't how to record the time of when it's changed from Awaiting SC. If I can get the date and time it was changed to Awaiting SC and the date and time it was changed from Awaiting SC, then I plan on making a calculated column which shows the total time spent in that status.
No RepliesBe the first to reply