How to automatically add a current date to a column when another column is changed?

0
votes

I'm working on a SharePoint list, and want to automatically add the current date to the attribute "Date X was implemented" when "Status" is changed to "implemented".

This is for SharePoint Designer 2010. I tried to solve the problem directly on the website with a calculated value and also in SharePoint Designer with a Workflow. Unfortunately, they both didn't work.

Here is the code for the calculated value I tried to use:

=IF( [Status] = implemented , Date X was implemented, "mm-dd-yyyy" )

And here is the SharePoint Designer Workflow I tried:

If Current Item:Status equals implemented
    Set Date X was implemented to Today
1
sharepointsharepoint-2010sharepoint-designer

1 Answers

0
votes

You could create a calculated column "Date X was implemented" in the list. Then use this formula:

=IF([Status]="implemented",TODAY())

enter image description here enter image description here

Another solution is creating workflow to achieve this: enter image description here

You need to run the workflow for all the entries to update the value. enter image description here