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

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

Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Red, Yellow, Green, Gray automation formula help needed for numerical ranges
I have a column called "metric data" and I am trying to create conditions for the status column (Already made it a symbols column) for Gray, Yellow, and Green Green = 1 (100%) Yellow= 0.01- 0.99 (1% to 99%) Gray= 0% =IF([Metric Data]@row = 1, "Green", IF([Metric Data]@row <= "0.01- 0.99", "Yellow", IF([Metric Data]@row =…
Report Question
Bringing this to the community before I jump in to try to figure it out because you are all so helpful and smart. If I have a report "Tracker C" whos filter brings in projects which have content in a comment field called "comments". I remove comments when I want a project on Tracker C to come off of the report. I want to…
Error message to
I am the owner of the sheet/workspace. I have given Admin Privilege to a few non-licensed users. One user was able to create a new report, and another user is getting this error message. Is this a Smartsheet issue?

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