Use of the system column to get the modified date

Hello everybody,

I am trying to automate the input of the modification date of a particular cell on my sheet. I figured that since this information is already available in the system column [Modified] - I'd like to take that info to put it into another cell (with Date properties)

Thanks in advance for the support

Chris

Find more posts tagged with

Manufacturing

Project Management

Comments

Mike Wilday

You can use the System modified column date as a reference point, but please be aware this date exists to express when ANYTHING on the row has been modified. So if you update text in any cell on the row, it will update that date. Its not focused on a particular column, it looks at the row in its entirety.

I recommend submitting a product enhancement request.

Andrée Starå

Hi Chris,

Depending on the specifics, the third-party service called Zapier could be an excellent option for this scenario. Is that an option for you?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Sign in to join the conversation!

Quick Links

Trending discussions

Forms
On the App - "In Smartsheet forms, is there a way to capture or upload an image directly into a specific column cell (per row) without using the Attachments field? I need each section of the form to have its own dedicated image, not just general attachments for the row."
Smartsheet Mobilizer Kit2/Best Practices
Hi - I am launching Smartsheet sessions at my organization for the next 3 months. The SS Mobilizer Kit2 Workspace I saved a few years back, the files are not loading. Is there a new resource kit? Also, I am writing up some best practices for our users: Examples: Names, separate first and last name into two columns. Email…
Workspace is still there but all folders are empty
Hey, I had a Project in January where I created multiple sheets, dashboards etc. Now I want to prepare the same project again but all folders are empty. Not a single sheet is left. How is that possible ? I upgraded to a paid account during that time and Iwanted to do that again but smartsheet do not delete everything if…