Forum Discussion
Solved
SharePoint List - Track Status Time
Is there a way to track how long a SharePoint list item stays in a particular category?
For example, we have three options in one of the columns. Is there a way to systematically capture the date/time the status changes (either via a report or in another column)?
- You could dig through the version history of a list item, but that sounds tedious. You could also create extra columns that you'd keep hidden: a time in/time out for each status and use a workflow that listens for list modifications and enters the date/time stamp with the expression utcnow() in each of those columns when the conditions are met. Then you could create calculated columns to measure the time between each in/out. These two links could help: https://powerusers.microsoft.com/t5/Using-Flows/Get-date-when-an-column-is-modified-in-a-SharePoint-list/td-p/871423 and https://wonderlaura.com/2020/08/25/flow-when-a-sharepoint-column-is-updated/comment-page-1/
- You could dig through the version history of a list item, but that sounds tedious. You could also create extra columns that you'd keep hidden: a time in/time out for each status and use a workflow that listens for list modifications and enters the date/time stamp with the expression utcnow() in each of those columns when the conditions are met. Then you could create calculated columns to measure the time between each in/out. These two links could help: https://powerusers.microsoft.com/t5/Using-Flows/Get-date-when-an-column-is-modified-in-a-SharePoint-list/td-p/871423 and https://wonderlaura.com/2020/08/25/flow-when-a-sharepoint-column-is-updated/comment-page-1/
- That worked! Thank you!
