Sharepoint 2010 Calculated Column: How to get value before item gets modified?

Question

I have a list that has a Status-field. If the status changes, a modified date in another column should indicate, when the status has been changed.

My idea was to create a duplicate of this Status-Column and create in a column, where the date is supposed to be, a function something like this:

=IF(NOT([Status]=[StatusDuplicate]),[Modified],[Stay like that(not specified yet)])

However, this (of course) doesn't work properly. The Modified-Date-field gets updated even if I just "edit" the item with no changes.

Does someone know a solution/workaround to solve this problem?

YogaPanda · Answer

You can capture the timestamp when the status column changed. See the link below for further details.

https://social.msdn.microsoft.com/Forums/office/en-US/b0aae71a-1f53-4ded-8cef-342c4d3f822e/capturing-timestamp-when-status-changes-in-a-sharepoint-2010-list?forum=sharepointdevelopmentprevious

/* Updated in 2/27/2018 */

If you want to show the timestamp when the status is not the starting status, you can use:

=IF(NOT(Status="Start"),TEXT(NOW(),"dd/mm/yyyy  hh:mm"),IF(ISBLANK(Status),"","NULL"))

This should work, let me know if you have any question.s

Sharepoint 2010 Calculated Column: How to get value before item gets modified?

One Answer

Add your own answers!

Ask a Question