Hi,
I am new to this site as well as to the SharePoint and was wondering if you could help me out.
I have a column in a SharePoint list called ‘STATUS’ and it has 3 choices: ‘Submitted’, ‘Rejected’ and ‘Approved’. I want to know when the status of a particular line was changed to ‘Approved’.
The motive is to find out how many projects were approved in the last 6 months. We do not have an additional column which states ‘date of approval’ otherwise I could have used this to query the approval date.
Can anybody please help me to find a formula / script to base a new column on (e.g. ‘PO Approved’) , so that I can query this information ?
I have seen in the version history for the list item that the information is present so can I use this?
Thanks in advance.
Hey Harpreet, welcome on board and thanks for the question.
To answer your question, I think you will need to write some C# code to develop an Event Receiver for your List. The Event Receiver would then fire when the item was updated which would then update your new column with today’s date, but only if the item was ‘Approved’.
There may be another way to achieve this, but this is the one that comes to mind as I am a developer by trade 🙂
