Add Column for Date Record is Closed
I want to create a new column that is a formula. The Status can be blank, Open or Closed. Once a record is closed it will not be reopened. If there is reason to do so, a new record will be opened and it will reference the original. This has only happened once. This date column should be blank unless the status of the record is closed, and when Closed, the date it was closed would appear. Am I overcomplicating this? is it as simple as an IF Statement? And yes, everything is on the same sheet.
Project Analyst | Core Quality Services (QMS Transformation)
Help Article Resources
Check out the Formula Handbook template!