I have a requirement from a client where they have a custom list called "Process" that has a two step review process, and they want to track how long it takes from:
- Creation to Processor 1 completing their task
- Processor 1 completing their task to Processor 2 completing their task.
For arguments sake, lets say we have 2 choice columns, P1 and P2 with choices "new", "in progress" and "complete", and I have turned on version control.
Is there a way to scour through versions to gather the Modified By and Modified info for when P1 was changed to "complete" and write that info into a pair of fields (i.e. P1Processor and P1CompleteDate) and the same for P2? The I could have
some DateDif calculated columns to provide the time lapse info required.
Is this a job for Versions.GetVersion?
Caveats: I have Site Owner permissions. no access in PRD to SPDesigner - basically CEWP! Also, the list would not be long, and I would set flags so it would only review/update items not previously updated.