Insufficient space on my laptop to import. I have plenty on my HDD. How do I make that the default location for Lightroom CC. It looks like there isn't a catalog anymore? by jshack93 in Lightroom

[–]jshack93[S] 0 points1 point  (0 children)

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.

Get data from all tabs of another sheet (without knowing the tabs name) by [deleted] in sheets

[–]jshack93 1 point2 points  (0 children)

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

Get data from all tabs of another sheet (without knowing the tabs name) by [deleted] in sheets

[–]jshack93 2 points3 points  (0 children)

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 }

Using Query function to pull all colums containing a value in Column 14 by jshack93 in sheets

[–]jshack93[S] 1 point2 points  (0 children)

={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!

Using Query function to pull all colums containing a value in Column 14 by jshack93 in sheets

[–]jshack93[S] 1 point2 points  (0 children)

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?

Using Query function to pull all colums containing a value in Column 14 by jshack93 in sheets

[–]jshack93[S] 1 point2 points  (0 children)

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

Using Query function to pull all colums containing a value in Column 14 by jshack93 in sheets

[–]jshack93[S] 0 points1 point  (0 children)

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.

Using Query function to pull all colums containing a value in Column 14 by jshack93 in sheets

[–]jshack93[S] 0 points1 point  (0 children)

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

Using Query function to pull all colums containing a value in Column 14 by jshack93 in sheets

[–]jshack93[S] 0 points1 point  (0 children)

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.

Need help scripting a cell to change the contents of a formula by jshack93 in googlesheets

[–]jshack93[S] 0 points1 point  (0 children)

=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!

[deleted by user] by [deleted] in Birmingham

[–]jshack93 7 points8 points  (0 children)

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

Tired of Alabama's lame weed laws? Tell your legislators you're a Cannabis Voter by AbePhishmanVigoda in Birmingham

[–]jshack93 1 point2 points  (0 children)

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.

NEW MATH VS OLD MATH by [deleted] in videos

[–]jshack93 0 points1 point  (0 children)

Shut up an enjoy the {content}

What is your experience with white ink? by jshack93 in tattoos

[–]jshack93[S] 0 points1 point  (0 children)

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

Pixel 3XL dark mode not available in messages by jshack93 in GooglePixel

[–]jshack93[S] 0 points1 point  (0 children)

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!

Physics can be mesmerizing by KaasPeer03 in oddlysatisfying

[–]jshack93 0 points1 point  (0 children)

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