How can I view all comments from a curated group of rows?

Meredith Rhodes
Meredith Rhodes ✭✭
inSmartsheet Basics

Here is my scenario: the regulatory staff on my team are transitioning to a smartsheet-based tracker to keep track of all regulatory tasks related to a clinical trial.

Each task (initial applications, protocol amendments, personnel changes, continuing reviews, etc) has its own row. In other words, one trial may have 10 to 100 different regulatory tasks / rows represented.

If there are 25 comments over 25 different rows that are associated with the same trial - is there a way that I can curate all of those comments into a report?

Thanks for any ideas.

Meredith

Tags:
· Share on Facebook Share on Twitter

Answers

Categories

You use the inbuilt system one:<\/p>
\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

This will auto-populate itself with the date (and time) of submission of the row (whether by form or sheet), nothing extra required.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":112011,"type":"question","name":"Automation: any change but blank","excerpt":"How do I specify that a cell value should change only if the trigger cell has changed to anything but blank. In this case there are 4 cells which can trigger the cell change. Currently I have it that if any of them change to any value that triggers a different cell change but I want that to occur for any value except a…","snippet":"How do I specify that a cell value should change only if the trigger cell has changed to anything but blank. In this case there are 4 cells which can trigger the cell change.…","categoryID":321,"dateInserted":"2023-10-23T14:13:51+00:00","dateUpdated":null,"dateLastComment":"2023-10-23T15:34:41+00:00","insertUserID":146968,"insertUser":{"userID":146968,"name":"Alta","url":"https:\/\/community.smartsheet.com\/profile\/Alta","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-23T15:31:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":151203,"lastUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-23T16:23:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":21,"score":null,"hot":3396147512,"url":"https:\/\/community.smartsheet.com\/discussion\/112011\/automation-any-change-but-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112011\/automation-any-change-but-blank","format":"Rich","lastPost":{"discussionID":112011,"commentID":401186,"name":"Re: Automation: any change but blank","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401186#Comment_401186","dateInserted":"2023-10-23T15:34:41+00:00","insertUserID":151203,"insertUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-23T16:23:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-23T20:28:41+00:00","dateAnswered":"2023-10-23T15:08:30+00:00","acceptedAnswers":[{"commentID":401166,"body":"

Hi @Alta<\/a>,<\/p>

You could set your conditions as OR for the 4 cells (add the extra cells and click on the \"and\" when you add the first one to change it to \"or\"):<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

If the different cells cause different outputs, then you would do something more like this with additional condition paths (selected by clicking the + button and selecting this option):<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

Hope this helps, but if you've any problems\/questions then just post!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":111889,"type":"question","name":"recurring annual reminder - contract renewal","excerpt":"I am trying to setup an automatic workflow to send me an annual reminder based on a date column that has a contract renewal date in it. When I do a custom automation I can allow it to recognize the date field on my sheet. seems like a simple task but I can't figure it out.","snippet":"I am trying to setup an automatic workflow to send me an annual reminder based on a date column that has a contract renewal date in it. When I do a custom automation I can allow…","categoryID":321,"dateInserted":"2023-10-19T00:00:19+00:00","dateUpdated":"2023-10-19T17:40:52+00:00","dateLastComment":"2023-10-23T15:58:23+00:00","insertUserID":164580,"insertUser":{"userID":164580,"name":"Dhoke","title":"Director of Talent Acquisition","url":"https:\/\/community.smartsheet.com\/profile\/Dhoke","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-23T15:58:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":166028,"lastUserID":164580,"lastUser":{"userID":164580,"name":"Dhoke","title":"Director of Talent Acquisition","url":"https:\/\/community.smartsheet.com\/profile\/Dhoke","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-23T15:58:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":38,"score":null,"hot":3395752722,"url":"https:\/\/community.smartsheet.com\/discussion\/111889\/recurring-annual-reminder-contract-renewal","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/111889\/recurring-annual-reminder-contract-renewal","format":"Rich","lastPost":{"discussionID":111889,"commentID":401189,"name":"Re: recurring annual reminder - contract renewal","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401189#Comment_401189","dateInserted":"2023-10-23T15:58:23+00:00","insertUserID":164580,"insertUser":{"userID":164580,"name":"Dhoke","title":"Director of Talent Acquisition","url":"https:\/\/community.smartsheet.com\/profile\/Dhoke","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-23T15:58:28+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-23T15:58:26+00:00","dateAnswered":"2023-10-19T21:56:55+00:00","acceptedAnswers":[{"commentID":400860,"body":"

@Dhoke<\/a> you can use that automation for the column you want to run it in. Just build a formula for the date in that column. For instance, if you have an Initial Date column and a Run Date column being the execution. You can put the following formula in the Run Date<\/p>

=DATE(YEAR(TODAY()), MONTH([Initial Date]@row), DAY([Initial Date]@row))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5187,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • Forms - how to set up a date field?

    Is there a way to format a date field in a form (for a sheet) to be set up for the date it's submitted? Like a TODAY formula or something? Thanks!!

  • Automation: any change but blank

    我怎么指定单元格值寿ld change only if the trigger cell has changed to anything but blank. In this case there are 4 cells which can trigger the cell change. Currently I have it that if any of them change to any value that triggers a different cell change but I want that to occur for any value except a…

  • recurring annual reminder - contract renewal

    I am trying to setup an automatic workflow to send me an annual reminder based on a date column that has a contract renewal date in it. When I do a custom automation I can allow it to recognize the date field on my sheet. seems like a simple task but I can't figure it out.

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

 Watch video