Selecting one row across multiple sheets for reporting

Nicolette Thomas

Is there a way to select/display just one row's information from multiple sheets into one report?

Meaning if I am using the same template across 25 sheets and want just the one parent row from each of these sheets to show on the report, is there a way to do this?

Each sheet has tasks associated with it and the parent row serves as the overall status of the project. However with multiple projects/sheets, I need that parent row from each of the sheets to provide to our executives to show them the overall individual status instead of looking at each sheet individually.

I'm new to Smartsheet so any help you all can offer is much appreciated.

Thanks,

Nicolette

Paul Newcome

Absolutely! You can either use cell linking to link the row from each project sheet into one Master Sheet, or you could include a checkbox column on each project sheet (it can be hidden from view to keep the sheet looking clean) where you manually check the box for that parent row. From there you would reference those sheets in your report builder and set your criteria to be for only rows where that box is checked.

Paul Newcome

Absolutely! You can either use cell linking to link the row from each project sheet into one Master Sheet, or you could include a checkbox column on each project sheet (it can be hidden from view to keep the sheet looking clean) where you manually check the box for that parent row. From there you would reference those sheets in your report builder and set your criteria to be for only rows where that box is checked.

Nicolette Thomas

Thank you so much Paul! I knew it had to be something simple. Thank you!

Paul Newcome

Happy to help! 👍️