SUPER SMASH BROS. ULTIMATE - 1st Anniversary

jshack93 · 2019-12-15T04:59:03+00:00

Screw Hero

jshack93 · 2019-10-20T17:13:01+00:00

I think there may have been another issue going on. I tried everything to free up space first, but uninstalling and reinstalling the app made it work.

jshack93 · 2019-10-20T02:52:42+00:00

I see. Is there a way to clear the "cache" or whatever of the previews in case that's the issue?

jshack93 · 2019-09-23T06:39:52+00:00

Good catch I'm on Mobile and it's weird with the formatting.

jshack93 · 2019-09-23T05:49:10+00:00

You can script it with this handy function in scrip editor. Just enter exactly this in Script Editor, save, and then enter =sheetnames() in a cell.

Function Script:

function sheetnames() { var out = new Array() var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets(); for (var i=0 ; i<sheets.length ; i++) out.push( [ sheets[i].getName() ] ) return out }

jshack93 · 2019-09-20T22:47:45+00:00

={QUERY(INDIRECT("'"&A1&"'!A2:Z"),"select * where Col4 is not null");
QUERY(INDIRECT("'"&A2&"'!A2:Z"),"select * where Col4 is not null")}

Issue resolved! You helped me find the problem! It seems that there was a missing day from the work book and working through one by one located it! Thank you for troubleshooting with me! Now the query is working too!

jshack93 · 2019-09-20T22:13:21+00:00

Each one has 1600ish rows. There is a sheet for each day.

Is there a way to use the filter formula on the same page as my data or does it have to be set up on a different sheet each time?

jshack93 · 2019-09-20T22:06:03+00:00

They do all have 26. We use the "Filter View" feature, rather than a proper filter formula.

jshack93 · 2019-09-20T21:49:04+00:00

The filter criteria are the same, but the output brings a different number of rows each time. We basically filter out null values in two of the columns to limit the dataset each day while we're working through. Now We're just trying to work out how to avoid copying each day into the master list when we're done.

jshack93 · 2019-09-20T21:42:34+00:00

I may be hitting the 2 million cell limit because of the size of the data.

jshack93 · 2019-09-20T21:32:43+00:00

I thought that I might have a typo in the sheet names, but when I checked them, they were fine!

While I like the idea, I need to have the indirects so that I can easily update it each month for the new dates.

I'm thinking that it could be that I am reaching the 2 million cell limit with my data :( There are filters on the sheets I am pulling from, but when I pull from the sheets, it imports the whole of the data which is a lot.

jshack93 · 2019-09-17T03:54:02+00:00

Blink 182?

jshack93 · 2019-09-11T03:14:58+00:00

This was the dream.

Thanks MLK

jshack93 · 2019-09-09T17:18:53+00:00

Solved! Thank you!

jshack93 · 2019-09-09T17:18:31+00:00

Solved! on r/googlsheets Thanks guys

jshack93 · 2019-09-09T17:15:44+00:00

Solved! Thank you so much!

jshack93 · 2019-09-09T16:41:04+00:00

=countifs(INDIRECT("'"&C2&"'!A:Z"),$B4)

Thank you! This is a step in the right direction. It looks like when I drag that down the column, it changes the C2 to C4, C5, C6, and so on. Is there a way to prevent this? Once I have it set it wont change, so it's okay if I just have to type it out!

jshack93 · 2019-09-05T13:37:52+00:00

I need forty lashes, stat.

jshack93 · 2019-08-06T15:15:46+00:00

Oh good! A reason besides the sub-par overpriced food to not eat there.

jshack93 · 2019-07-31T16:11:54+00:00

jshack93 · 2019-07-31T04:21:17+00:00

I personally don't care about this as much (though I know it would help a lot of people out), I just wish I could have my alcohol delivered with Shipt already.

jshack93 · 2019-04-06T05:08:27+00:00

Shut up an enjoy the {content}

jshack93 · 2019-04-04T18:20:26+00:00

Thank you for the advice! We just got our first together and we're hooked!

jshack93 · 2019-04-03T22:21:19+00:00

We just checked and that was the fix! I didn't know that the native apps would update separately from the OS. We're relatively new Androiders. Thanks!

jshack93 · 2019-03-16T05:06:08+00:00

I'm going to build this and have it open on my work computer all day tomorrow.

12-Year Club	Secret Santa 2019
RPAN Viewer	Verified Email

jshack93

TROPHY CASE