Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

auto date entry multiple columns

✭✭
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

Trending in Smartsheet Basics