Insert Date when field changed to closed

[Sam87]

I imagine this will be very simple for someone to answer, but in the date formula field, what is the proper syntax to populate that date field [call it A] automatically to today’s date when another field [call it B] is changed to 'Closed?" Additionally, i want to lock this from modification.

[Heino_Matthee]

Create a action that sets the date field to Today() and then create a workflow for “updates only” with “if this is true” to [B] = Closed. If you intend to edit other things for this entry you might want to look at [_THISROW_BEFORE] = Open and [THISROW_AFTER] = Closed kind of expressions. Otherwise the date will be set to today everytime you edit something after the fact.

[Lynn]

Hi @Sam87
Have you checked out change time stamp?