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

Meredith Rhodes

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

Paul Newcome

You would need to have a column on the source sheet that has the trial on every row. Then you can create a row report to pull in rows where trial is "XYZ", and the comments should be there in the report.