Counting Status Changes



I'm working on a document tracker that has statuses changing back and forth several times. I'm wondering if anyone has any ideas how I could count each time the status changes.

For example, they default to Not Started. Once changes from Not Started to Awaiting Requirements, that's 1. From Awaiting Requirements to Sent to Lab, that's 2. From Sent to Lab to Review, that's 3. And if something was wrong and needed to go back to the lab, so Review to Sent to Lab again, that would count as 4, etc. etc. etc…

I know I can view this in the Cell History and in the Activity Logs, but I'm looking to get an idea of how often each document type, that we are tracking in here, has a status change. this means looking at the activity on each cell for hundreds of rows would be out of the question.

Any advice is appreciated! Thanks!


Best Answer

    JIDEATTURRA ✭✭✭✭✭✭
    Answer ✓

    You could do a workflow to copy the rows to another sheet each time the status changes, then count the number of rows copied to see the total number of status changes.