auto date entry multiple columns

josh_m
josh_m ✭✭
edited 12/09/19 in Smartsheet Basics

i have multiple columns in a sheet for various tasks that need to be completed (water, electric, etc.).  the columns are a dropdown to pick from complete, in progress, not started.  i wanted to insert a column next to each task that would insert the current date & time when the status was changed to complete.  i attached a mock up picture of what I'm hoping to accomplish

The auto-number functionality does not appear to work for multiple columns.

Is there a way to accomplish this?

auto date.jpg

Comments