I have a list where in we are capturing Completion Month date. It can be updated by users if required. I need to have a record of number of times this value is updated for each individual row starting from default value of 0.

Can I create a calculated column based on above requirement.

1 Answer 1

  • Add a number Column 'Completion changed' (don't need a Calculated Column)
  • Add a text column 'previous Completion Date'
  • Create a SharePoint Designer Workflow
    Set to trigger on Item changes

Workflow steps:

  • read value from previous Completion Date
  • read value from Completion Date
  • if values are equal then do nothing
  • if values not equal then

  • read value from Completion changed

  • increment value
  • write value to Completion changed

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.