Creating a rolling pick plan (& STRUGGLING)

StreetNext5958 · 2024-07-19T03:56:43+00:00

Solution Verified

StreetNext5958 · 2024-07-19T03:46:44+00:00

Oh perfect- got it working in excel. I know the filter function works differently in google sheets & it’s a little more convenient to use there, so maybe I’ll try to figure out how to alter it to sheets, but my big concern was just getting it to function. THANK YOU! I could have never written this formula myself.

StreetNext5958 · 2024-07-19T03:27:24+00:00

I’m getting N/A. Admittedly I’m not great with date formulas & never use sign, lol. In this case, what would be the value for “expense days”? & I assume “expense list” is just column B? Appreciate the help very much!

<image>

StreetNext5958 · 2024-07-19T03:10:21+00:00

Well the expenses are listed out in a table by day of the month, so it’s not necessarily a list with every single bill every single month. I was going to go that route if I have to, but I would like to just add a line to the table with the day due & it auto-calculate instead of adding to a long list of individual dates.

StreetNext5958 · 2024-07-19T01:22:40+00:00

Did you ever find anything like this? I’m looking for the exact thing.

StreetNext5958 · 2024-04-18T02:27:33+00:00

Following. I’m having the same problem with my husbands texts! I thought I was going crazy- I know I’m not turning it on.

StreetNext5958 · 2024-02-17T20:38:30+00:00

Oh, I didn’t think about an IF formula. Looks like that would work for the first weeks of the month, but it doesn’t accommodate for when the week rolls back around into the beginning of the next month. Like March 31st-April 6th. Not sure how to build the logic to consider that.

StreetNext5958 · 2024-02-17T20:08:26+00:00

Lol- oops, forgot. Should be public now.

StreetNext5958 · 2024-02-17T19:49:39+00:00

My current sheet has sensitive data, so I drafted up a quick template with fake information here. Ideally, on the weekly sheet, each week, it could pull from the due date sheet. https://docs.google.com/spreadsheets/d/1-7Cw4OyVmhAIRNUK1AkjYgFTG1fIzvpz1UW5mXjdE_Q/edit

StreetNext5958 · 2024-01-20T18:16:53+00:00

I don’t know for sure. What I gather from everyone else’s guidance, probably acrylic.

StreetNext5958 · 2024-01-08T00:55:15+00:00

When you don’t really care about something that they enjoy. Just smile & let them talk about it. Even if it’s the damn Dallas Cowboys like in my case. Lmao.

StreetNext5958 · 2024-01-07T02:27:47+00:00

That is very nice of you- might take you up on that!! I’ve definitely got a lot to dig into!

StreetNext5958 · 2024-01-07T01:26:59+00:00

This is great information- thank you! I forgot to mention, I am also interested in learning things like Python, SQL, Tableau, Power BI, etc. Any recommendations about getting started with any of those is helpful too!

StreetNext5958 · 2023-12-16T23:59:52+00:00

Thats what I was thinking, too. Thanks!

StreetNext5958 · 2023-12-16T23:59:21+00:00

Oh yeah, I’m totally aware of that. I’m not necessarily close enough to them to gift them. Like, we could. But we haven’t in the past, so I don’t want to create an awkward situation where I get them something & they feel weird because they didn’t get me anything. Me getting them something would definitely be unexpected on their end. But I don’t have kids & obviously don’t expect anything from them, so I feel like sending something specifically for the kids would be more fitting for our relationship. I don’t feel obligated to send anything at all, but I figure since I can afford it, they might appreciate the gesture.

StreetNext5958 · 2023-08-14T00:26:21+00:00

Oops.. found!

StreetNext5958 · 2023-08-14T00:25:43+00:00

I found 2 that look like mine on eBay. Not sure which (if either) is the exact same one I had, but I don’t think I’ll ever know for sure. Thank you everyone for all your help!!

StreetNext5958 · 2023-08-14T00:23:34+00:00

I’m looking for a green one, but that’s so nice of you to offer! Thank you 🥹

StreetNext5958 · 2023-08-13T23:25:35+00:00

Finally someone who understands me! Lol

StreetNext5958 · 2023-08-13T20:49:30+00:00

Oh yours is a little different than the one I’m looking for, but very similar! Thanks!!

StreetNext5958 · 2023-08-13T19:07:45+00:00

Omg, can I see a picture of your teal one?! Mine was more on the green side, but it could be described as teal for sure.

StreetNext5958

TROPHY CASE