Counting Field Changes

Question

I need to setup some type of counter on how many times a field has been changed in my SharePoint list. Is there any way to do this without coding? If so please explain.

Thanks!

Answer 1

Enable List item versioning. You can see all the changes made to the item with the field name. That's a no code solution.

Workflow Solution:

1. Create Counter columns in the list for different fields
2. Create one more list with the exact same columns + lookup column on the ID of original list
3. Create a workflow which will run on create and edit on original list
4. In the workflow get item from second list based on the ID via help of lookup column on second list
5. If no item exists create one with the exact field values from initial list in second list
6. If item exists, Compare every field from first list and second list
7. If value is not the same increase the counter of that field in First list
8. Update the item in second list with the new values.