Last Update Column
I created Automation to insert a Date in a column ("Last Update Date") when a new comment is added. However, the whole column is updating with 'Today's Date' each time it's saved, not just the cell for the specific row. So everything looks like it's just updated.
How can I change this? Thanks in advance
Best Answer
Answers
-
I built this same automation into a sheet of mine and it is only recording a date on the line the comment was added. Have you tried deleting the automation and restarting?
-
Hmm, will give that a go... it's just annoying every time it does it and I have to go in and edit each row individually!! Thanks.
-
-
Actually is there a way of Smartsheet extracting the last comment date from the comments... otherwise I'm going to be doing this manually?
-
-
@Samuel Mueller I think you know the answer to the above if she can pull the last comment.
-
Hey@Pamela Clapp just to say THANKS, that did work. Glad I only had 55 rows to reset!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.6K Get Help
- 435 Global Discussions
- 152 Industry Talk
- 495 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Good day Smartsheet Team, Getting an unparseable error on this formula: =IF($Name@row <> "",(SUMIFS({Expense}, {Period},1, {Type}, OR(@cell = "RES602782", @cell = "RES602497")),"") Trying to pull in a…
- I am working in a separate sheet for calculating metrics. I want to count the number of items in a referenced date range in another sheet that meet certain year criteria. For example, I want to find t…
- I have a column that is a contact list where a single or multiple staff members can be selected to be scheduled. I'm trying to create a formula that counts how many times each individual's names are l…