Report connecting multiple sheets

I would like to create a single report pulling data from multiple sheets based on primary column, start end date, Assigned to and status.

How could I achieve that? Currently even if I add multiple sheet to report criteria it pulls data only form 1 sheet.

Find more posts tagged with

Reports

Project Management

Media & Entertainment

Comments

Shaine Greenwood

Hi Agnes,

To ensure consistency, you'll want to make sure that the column names are the EXACT same on all of your source sheets. This includes letter casing. (A report will treat a column titled "Assigned to" and "Assigned To" as two separate columns.)

Next, you'll want to ensure that all of your columns have matching column types. For example, all of your Assigned To columns should all be Contact list columns, Start and End Date should be Date columns, etc. More on column types here: https://help.smartsheet.com/articles/504619-column-types

Finally, your report gathers data based on the criteria you've selected in the report builder. If your report builder criteria doesn't find anything from certain sheets, it's likely that you'll need to add (or remove) criteria so it will include the sheet data you're wanting. More info on building reports can be found in the help center: https://help.smartsheet.com/articles/522214-creating-reports

tcanelli41471

So you can't create a report that uses some columns from one sheet and other columns from another sheet? I'm trying not have 100+ columns in one sheet and need to create reports for different functions.

BDuplain

Have there been any updates on this?

Sign in to join the conversation!

Quick Links

Trending discussions

Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto