Drop down selection and cell updates

I have a column with drop down single select type name SLC Status. The entries in the drop down are "Requested", "In Review" , "Progress", "Testing", "Completed".

There is a separate column for each entity ("Requested", "In Review" , "Progress", "Testing", "Completed").

My goal is- when Requested is selected from the drop down then current date and time should populate in the column under Requested for the row should show current date and time, when a change to the drop down is made then current date and time should be populated in the respective rows.

Is it possible to get it?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!