I’m using a single select field to note the different statuses in a production workflow. I’d like to create a field to mark the date that the record was set to a particular status, “Ready to Publish,” and keep that date persistent even when the status moves on to another stage.
I started with this formula, which does return the date something is set to the correct status:
IF(Status=“Ready to Publish”, TODAY(), “”)
But then goes blank when the status updates to the next stage. How can I make the date persistent after the status changes? Thanks for any help.