IDEA: Create Cross-sheet references from reports

Just want to throw this out there. I am referencing three rather large sheets and trying to bring in some COUNTIF data but keep getting told that I am referencing too many cells. This is prohibiting me from creating the data I need.

It would be great if you could do cross-sheet references from reports. This would allow me to filter-down the data I need before I actually do the reference, therefore linking fewer cells.

Submit a product enhancement request with me if you think its a good idea!

Find more posts tagged with

Formulas

Reports

Comments

Kirstine

Sorry - I got a bit lost...! Do you mean being able to reference individual columns, as opposed to one big block that includes all the columns in between?

I've had that issue with SUMIF and ended up creating a 'duplicate' column closer to the second column I needed to reference, just to make the formula work!

Mike Wilday

Hi Kirstine, I have several large sheets that I wanted to combine into roll-up data on a single new sheet. What I discovered is that after doing a Countifs formula looking at 5 different columns of criteria on the first sheet, I wasn't able to do the same thing with the same 5 columns on the second sheet. I got a message that my current sheet had reached the 25,000 cell linking reference.

My thoughts are... if I can create a report that pares down the data I need to just the rows I need, then a cross-report reference would allow me to look at less rows and allow me to link in more sheets.

Paul Newcome

I'd love this too. I submitted a request a few months back for this very thing.

Marya

This feature would be extremely helpful, even for those of us who aren't managing large numbers of rows. I hate to have to re-create the logic used in a report each time I need a COUNT or COUNTIF. It would be much easier to pull from reports that already display the data I need.

Sign in to join the conversation!

Quick Links

Trending discussions

Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Countifs result not matching filter
In my sheet, I have a filter for 2 values (see below images). The result is 294 In my report this formula yields 304. =COUNTIFS({helper-child}, "1", {gapStatus}, <>"Rejected (not a GAP)", {gapStatus}, <>"removed - duplicate", {gapStatus}, <>"removed - not valid") Why are they not matching? What am I missing?
Using CONTAINS in a MAX(COLLECT) function
I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with: MAX(COLLECT({Schedule…