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

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?

Find more posts tagged with

Reports

Project Management

Cell linking

Comments

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

Screen Shot 2018-03-01 at 10.27.07 AM.png

Screen Shot 2018-03-01 at 10.30.37 AM.png

Screen Shot 2018-03-01 at 10.34.10 AM.png

Sign in to join the conversation!

Quick Links

Trending discussions

SUmmary in Report Widget
How can i create a Report widget that only shows a status with "red status" from my main data source? Do i need to create a separate data source on just my "red status"
Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…