Question:

Update [Closed On} When Status = Closed

SharePoint

Gabriel: 2 weeks ago

I am wanted to add similar functionality to the "Created On" Date column for my "Closed On" column. I want the date to automatically populate once I change status from Active or Pending to Closed, and want it to show once I save an item with this status change. Is this possible?

Answer:
Leilani: 2 weeks ago

Create calculated column Closed On with below formula:

=IF(Status="Closed",Modified,"")

Select Date and Time as data type for calculated column.

enter image description here