I have a custom list that used to manage the issues and complaints of customers and there is a column called "Dept." to show where the complaint is right now. Once the issue is closed, I want to know how many days have been taken by each department to complete the issue. Any one can help please?
Not sure how you define “close”, but you can build a flow to trigger on item modification and update the days between the last modification day and
Created to a custom column.
The process of the flow would be as following:
When an item is created or modified > Condition:
Closed is equal to
Yes > If yes: Update item.