How can I make SharePoint Calculated Columns to know who has edited some columns data?
I want to know who is editing specific columns, not modified by, and not using version history on each item.
Any help would be appreciated!
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
Easiest way is version history. It shows who modified which columns and when.
If you don't want to use version history, this approach will work for a list:
I have many lists that use this technique and show the change history for monitored fields on a separate view of the InfoPath form.
You can not do this out of the box. Development is required (or workflow like Jammin said)
An alternative is to create an event receiver.
This event will run whenever an item is updated. At that time, through code in C#, you can verify which columns were modified and by which user.
And you can create new columns to register the author of such changes.
It is coding required, but it is possible to do.
Possible through custom SharePoint Designer workflow and lots of hidden fields.
Assume 10 columns of visible info Column1 has data, column11 has what data used to be, column21 had column editor
You will need steps 1&2 for each column you want to monitor. They can all be in the same workflow.