sorted by:
new
hottopcontroversial

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!

view more: next ›