Set and Retain Date Field Value

Hello all!!

I have a dropdown, single select field named STATUS with values of SUBMITTED and RESOLVED. I also have a date field named RESOLVED DATE. I am trying to automagically set the RESOLVED DATE to the date the user selects the RESOLVED status and then retain that date everyday unless the status is changed to SUBMITTED. I have tried many variations of formulas and additional cells but continue running into #CIRCULAR REFERENCE errors because I am trying to determine if the RESOLVED DATE needs to be set to TODAY().

Please let me know if anyone has any ideas...

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!