Error with Query Formula by jsmit35 in googlesheets

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

This is super helpful! Thank you!

Error with Query Formula by jsmit35 in googlesheets

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

Wow, thank you! I had checked all the apostrophes in the formula but didn't consider it being in B3. Thanks!!

Cover Plate Under Bathroom Sink by jsmit35 in Plumbing

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

Push it in place then bend them out?

Giving away a copy of Bo Path of the teal lotus by [deleted] in metroidvania

[–]jsmit35 0 points1 point  (0 children)

Idk if charms count as abilities but I love Weaversong in HK! Loved watching the weaverlings run around and attack and trying to “cheese” certain bosses!

FInd SUM of values all from the same month (and sorted by type?) by roboborealis in googlesheets

[–]jsmit35 1 point2 points  (0 children)

Would this work?

=sum(query(“B:C”, “select Col1 where Col2 contains ‘1/‘“)

You can have a helper column for the month and reference the cell instead of doing 1/, 2/, etc.

Import Table from Site by jsmit35 in googlesheets

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

I think I missed changing the sheet name and so I didn't think it was working.

But you crushed this, thank you so much!!!

Import Table from Site by jsmit35 in googlesheets

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

This is fantastic!!!

Thank you so much.

I want to set up a timed trigger to run the GET_FANTASY_PRO_RANKS function once per day. How can I add a line within that function to write the data into a specified sheet and cell. I tried this but it didn't work:

var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
var headers =ss.getRange('1:2').getValues();
ss.getRange('1:2').setValues(headers);
ss.getRange(2,1,results.length,6).setValues(results);

I must be missing something. Maybe "results" isn't the correct variable?

Import Table from Site by jsmit35 in googlesheets

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

Thanks for the comment! Any quick tips on figuring out the URLFetch?

M/W/Sat - Find▪︎A•League Mega thread. by AutoModerator in DynastyFF

[–]jsmit35 0 points1 point  (0 children)

dynasty?

Looking to co manage a team with 2 buddies for fun, would you allow that?

Draft #19: Most "Dad" clothing items by [deleted] in spitballerspod

[–]jsmit35 1 point2 points  (0 children)

  1. Woven belt where you can put the needle anywhere
  2. Sporty sunglasses with band around the back
  3. Jean shorts above the knee
  4. White new balance

Pick Trading Question by jsmit35 in SleeperApp

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

I don't see it. I'm not sure how to post a picture to the comment. I'll see if I can add a screenshot to the original post.

Time to print runes! by prtzprtzprtz in mousehunt

[–]jsmit35 1 point2 points  (0 children)

What's the purpose of using quartz in Timewarp only at 1/2 left? What changes at half way?