How do I write formula to capture date field changed to approved

I am trying to populate a date column with the date that another column is approved. I am befuddled. My formula returns today's date but it changes every day.



=IF([BIC Approved]@row = "approved", TODAY())

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!