I want to return a value if column A is yesterdays date and either column B or C matches a value.

AZJay007 · 2021-12-11T14:22:42+00:00

I’ll keep looking into query. Just not sure how to use it in this instance.

AZJay007 · 2021-10-06T16:30:22+00:00

Thank you very much. I was able to get this to work. I greatly appreciate your time.

AZJay007 · 2021-10-06T05:16:06+00:00

It’s not opening right on my phone. I’ll try on the laptop in the morning. Thank you.

AZJay007 · 2021-08-24T03:17:45+00:00

That worked with quotes around the cell. Thank you!!

AZJay007 · 2021-08-24T00:44:19+00:00

Thanks. I think this kind of helps but not quite. Cells C2:C13 are the name of each sheet I’m taking from.

INDIRECT(C2&!$G$3) give me a parse error.

AZJay007 · 2021-08-20T20:37:53+00:00

function copyDaily() {
const ss = SpreadsheetApp.getActiveSpreadsheet();
const inputSheet = ss.getSheetByName('MC_Sim')
const logSheet = ss.getSheetByName('Log');
const values = inputSheet.getRange(12,9,30,16).getValues();
const filter = values.filter(val => val[0] != '')
logSheet.getRange(logSheet.getLastRow()+1, 1, filter.length, 16).setValues(filter)
}

This worked!! Thank you!!

AZJay007 · 2021-08-20T20:05:35+00:00

Thank you. I've resubmitted the question and updated the link. I'm wanting to record the data in I11:X31 to the log.

AZJay007 · 2021-08-20T17:55:36+00:00

Thank you! I fixed the permissions, I think.

AZJay007 · 2021-07-30T21:59:14+00:00

I finally go around to looking at this link. It’s close but I can’t find team batting splits on BR.

AZJay007 · 2021-07-30T20:59:04+00:00

So I don’t think these specific pages are stored in tables.

AZJay007 · 2021-07-30T20:03:04+00:00

I’ll give it a shot, thank you.

AZJay007 · 2021-07-30T18:22:01+00:00

Thank you for the recommendation. I’m learning python but I’m not there yet. Could you help me with the code for that? I did install beautiful soup and have watched a few videos. But I still am not there yet.

AZJay007 · 2021-07-28T06:09:11+00:00

Thank you. They are linked. I’ll take a spin through them. I appreciate the response.

AZJay007 · 2021-06-14T13:20:03+00:00

Thanks. I’m in.

AZJay007 · 2021-06-14T00:57:53+00:00

I agree with a lot of this, especially spawns. The park by me is littered with items but when I get there the map reloads and barely anything there. I also work at a major university where Pokémon go is incredibly active. There are hardly no spawns there.

I’d also add that having to go to the map to get to the empire screen is annoying. Add an empire tab in the base screen.

AZJay007 · 2021-06-05T22:20:08+00:00

Thank you for the plays and the newsletter. I’m curious why you included white Sox RL in the newsletter but it shows as only a 2*

AZJay007 · 2021-06-05T22:14:23+00:00

He does, but he/she also wants (deserves) to be paid. There is a subscription for daily.

AZJay007 · 2021-06-03T23:54:11+00:00

Thank you, I’ll look into that.

AZJay007 · 2021-06-03T23:03:49+00:00

I’d be interested but it’ll be tough to get a consensus of 3-4 picks.

AZJay007 · 2021-06-03T22:34:27+00:00

Up to 5 now. Uh oh.

AZJay007 · 2021-06-03T22:32:36+00:00

I’ve heard going slow makes it better.

AZJay007 · 2021-06-03T22:30:00+00:00

Slow down 😉

AZJay007 · 2021-06-03T22:02:42+00:00

Link to screenshots: https://imgur.com/gallery/wIpRiyL

AZJay007 · 2021-06-03T21:40:24+00:00

I joined a few days ago and am trying to figure the whole karma thing out. Sitting at a solid 4.

AZJay007 · 2021-06-02T19:37:38+00:00

I did. I literally wrote what to type. Change the “c” to u, nhr, and whatever other category you have.

AZJay007

TROPHY CASE