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.

Meredith

Meredith Rhodes, PhD

ClinicalTrials.gov Specialist

UW School of Medicine & Public Health

UW Clinical Trials Institute

mkrhodes@clinicaltrials.wisc.edu

Answers