How can I view all comments from a curated group of rows?
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.