The formula works when I type manually, but when I try to get the references of the tabs inside the cells it doesn't work, can someone help me?
I tried to put it like this, but it didn't work.
Asked
Active
Viewed 48 times
0
-
share a copy / sample of your sheet with an example of the desired output – player0 Nov 19 '22 at 16:55
1 Answers
0
try:
=QUERY({REDUCE({"","","","","","","","",""},
FILTER(L5:L, L5:L<>""), LAMBDA(a, b,
{a; IFERROR(INDIRECT(b&"!G1:O"), {"","","","","","","","",""})}))},
"where not Col8 is null", )
where L5:L is your:
see: https://stackoverflow.com/a/74483215/5632629
UPDATE:
=QUERY({REDUCE({""\""\""\""\""\""\""\""\""};
FILTER(SHEETSNAME(); REGEXMATCH(SHEETSNAME(); "sin")); LAMBDA(a; b;
{a; IFERROR(INDIRECT(b&"!G1:O"); {""\""\""\""\""\""\""\""\""})}))};
"where not Col8 is null"; )
player0
- 124,011
- 12
- 67
- 124
-
-
https://docs.google.com/spreadsheets/d/1KVyLhBRamHyjq_DD92X78OfBvzh0bUDTnf_WTojTnpg/edit#gid=2097694625 – Saulo Moté Nov 21 '22 at 12:59
-
-
https://docs.google.com/spreadsheets/d/1KVyLhBRamHyjq_DD92X78OfBvzh0bUDTnf_WTojTnpg/edit – Saulo Moté Nov 24 '22 at 02:42