Auto populate date column when column is checked off formula

Hello! I need help figuring out a formula for the following...

  • 1 - Date Column Title: Handoff Date
  • 2 - Dropdown Column Title: Onboarding Progress

Essentially, when the status of the 'Onboarding Progress' reaches "handed off to qualification" and is checked off in the dropdown there a formula that will automatically populate the handoff date? So the date will fill in when that dropdown is checked off.

Hope that makes sense and thanks in advance.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!