Automation - Record a Date

AAL

AAL ✭✭✭✭

06/15/23 in Smartsheet Basics

I have a question regarding how to use the automation to set up the following:

when the Notes column is changed, it will record the date. However, it keeps saying I don't have the Date column and actually I have a Start Date column in my Sheet, so I don't know what's wrong with this. Would you please advise me on how to fix this? Thanks!

0 ·

Answers

Carson Penticuff Community Champion

06/16/23 edited 06/16/23

Are the date columns "formatted" as dates?

0 · Share on Facebook Share on Twitter
AAL ✭✭✭✭

06/16/23

Yes, please see below.

0 · Share on Facebook Share on Twitter
Genevieve P. Employee

06/16/23

Hey @AAL
It looks like this may be a duplicate post - here's a link to the response I have on your other thread:
https://community.smartsheet.com/discussion/comment/381001#Comment_381001

Cheers,
Genevieve

Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Why does Smartsheet add empty rows to sheets? Can this be disabled?
If I delete empty rows on a sheet, after saving and reloading, Smartsheet will add 10 empty rows to the bottom of the sheet. Example: My 66 rows becomes 76 rows (10 empty). 50 rows becomes 60 rows (10 empty). When I use a "Copy Row" automation, Smartsheet adds enough empty rows to ensure the destination sheet has at least…
No option to deselect "notify people" when sharing a sheet?
This discussion was created from comments split from: SmartSheet sharing - a frequently asked question - is there a better way to share items?.
The smartsheet to copy rows to when setting up automation doesn't show up in search
I'm trying to set up an automation to copy rows of a smartsheet into another one with only one trigger and condition. I get to the end to select a smartsheet to copy the rows to and the smartsheet will not come up in the search. I'm set up as admin for both sheets and the new smartsheet I'm copying to was set up last week…

Help shape the future of Smartsheet.
Share your ideas and feature requests.