How to create Report/Chart/Sheet for overview of many?

Frank Durocher

We have a Sheet for every project. Every Sheet is basically a checklist. The checklists are similar but wording and order of the tasks are different.

I want to create something that will bring in just the "Completed" checkbox and the Primary Column of each Sheet/checklist so that the overall status can be easily seen. How can I accomplish this?

Ideally, it would work like this: I have Checklists "House Chores", "Yard Chores", and "Pet Chores". Column A would be the Completed checkbox from "House Chores", Column B would be the name of the chore, and then Column C would start over for the next checklist by showing the Completed checkbox from "Yard Chores" followed by the name of the chore in Column D, and so on with Columns E & F.

Does that make sense?

Shaine Greenwood

Hi Frank,

You can create a report for this, but the rows will still be brought in on their own lines and as separate columns. (See my first screenshot.)

If you made all of your column names across your sheets the same, you could aggregate this in two columns. (Second screenshot.)

Otherwise, if you want this data to be displayed side by side in some way, you could create multiple reports, and then add reports widgets to a dashboard that show this. (Last Screenshot.)

More on creating reports in the help center: https://help.smartsheet.com/articles/522214-creating-reports

Here's one of our help articles on dashboards: https://help.smartsheet.com/articles/518547-creating-editing-a-smartsheet-sight