I need a report where multiple report columns can reference the same sheet column

Connor Blancato · 04/14/21

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!

Paul Newcome · 04/14/21

Are you able to provide some more details and possibly some screenshots with mock data and/or examples of what should be pulled?

Connor Blancato · 04/14/21

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?

Paul Newcome · 04/14/21

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?

Connor Blancato · 04/14/21

Yes but it does not display the data exactly how I need it.

Thank you very much!

Paul Newcome · 04/14/21

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?

I need a report where multiple report columns can reference the same sheet column

Answers

Categories