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?
Question:
Update [Closed On} When Status = Closed
Gabriel: 2 weeks ago
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.
- WordPress questions and answers
- SharePoint questions and answers
- Drupal questions and answers
- Magento questions and answers
- Salesforce questions and answers
- Joomla questions and answers
- Tridion questions and answers
- Craft CMS questions and answers
- CiviCRM questions and answers
- Sitecore questions and answers