Lock in a date once once a criteria has been reached


I am trying to work on a formula where once a status has changed to "Completed" then it will give the capture of the date in a completed date cell. But when the next year rolls around the status will change to Pending, but I need the capture date to stay as is until it reaches Completed again....not sure if that make sense or not :-)

Thanks in advance.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!