Capture Snapshot of Linked Cell at a point in time

I would like to capture the value of my Current Launch Timing (QC Release) when projects are submitted for Gate 4 automatically. Both columns are Date columns. Current Launch Timing (QC Release) is currently linked to the project plan. I don't want the value to continually update as the timeline updates. There doesn't appear to be a workflow that will capture the value for me (if there is, please let me know!) I have this formula that will capture the date when triggered, but once triggered, it will continually updated. I'm open to any suggestions. Would converting to text somehow work?

=IF(ISDATE([Gate 4 Ready to Route Date]@row), [Current Launch Timing (QC Release)]@row, "")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!