Is there a way to create new lines on smartsheet based on a comment created on another sheet?
We have a requirement to keep an audit record of comments being created so we can track the issue.
Bascially if anyone adds a comment to a row on sheet1, we want that comment and sheet name logged in another sheet.
Is this possible?
Answers
-
There's actually a newer feature called “Latest Comment”. Just create a new column, and choose the “Latest Comment” column type. More on that here.
After that you could create an automation in your source grid (where the comment was made) to Copy the row to another grid upon the trigger of “when rows are added or chagned”, and you can select the “Latest Comment” field changes to “Any value”. Then under the Select Action section, you would choose Copy Row, and then select which grid to copy to.
Hope that helps!
BRgds,
-Ray
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives