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
Comments
-
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.
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives