Forum Discussion

GuvD's avatar
GuvD
Copper Contributor
Dec 13, 2024

Status Change tracker

#Sharepoint 

 

Hello, 

I have a list with a column  " Status"  . We have "open" " rejected" " sent to vendor" " closed" 

Can we track the status changes in Sharepoint and measure how long it takes for each case from the " open " to the "closed " status?

 

We would like to measure performances if this is possible.

 

Best Regards GD.

Lists
Microsoft Lists
SharePoint Embedded
SharePoint Online
SharePoint Server
  • NicolasKheirallah's avatar
    NicolasKheirallah
    MVP
    Dec 13, 2024

    You have version history, so you can compare it there when it was last modified

    Another solution is to have a field that does that and is inputed using power automate

  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    Dec 15, 2024

    I would go the Power Automate route as you can check whether it is just the status column that has been updated and if it has then calculate the difference between open and closed dates and put that number into a separate column.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Resources