I need a report where multiple report columns can reference the same sheet column
I need to set up a row report. I am trying to set up multiple report columns that reference a single sheet column (although that single column is present in every underlying sheet.) The row report seems to only allow the sheet columns to be summarized once. Although each report column would be referencing the same sheet column, the filters would be different. Is there any way I can have multiple report columns referencing the sheet column?
Sorry if this was confusing... some of the terminology might be slightly off. Thank you!
Answers
-
Are you able to provide some more details and possibly some screenshots with mock data and/or examples of what should be pulled?
-
Sure, so in every smartsheet there is a column that looks like this
I want to make a report that includes several underlying smartsheets that all have this column. I want the report to reference this column three times. I want the report columns to look like this.
However, each time I try to reference the underlying column multiple times, I cannot click the button more than once
How do I get it so that my status column is referenced more than once?
-
You won't be able to break it down exactly the way you are wanting, but have you looked into the Grouping options on the report?
-
Yes but it does not display the data exactly how I need it.
Thank you very much!
-
How exactly do you need it? Are you able to manually enter some mock data into a sheet that reflects what you are wanting in your report?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives