Selecting one row across multiple sheets for reporting


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.



Best Answer