Autopopulate Date based on Column


Looking for the formula that will automatically put the date when a column is checked "yes". It needs to be the date that the column changed to "yes", not todays date (as that will keep updating as days go on).

When the column "Sent to Payroll" changes to yes, I want the date that it changed to "yes" to show in "Date Sent to Payroll" column


  • Jordan


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!