Auto Populate Today's Date


When a condition in "Column A" changes to "YES", I want the date in "Column B" to automatically enter today's date. How can I do that. If I use the TODAY function, that cell will update to today's date every day - and I only want the date "Column A" changed to "YES".


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!