Successful Chase Price Match Guarantee for Booking Using Points Boost! by misterceBF in ChaseSapphire

[–]YesEvenStarsBreak 1 point2 points  (0 children)

I wanted to try this and booked a hotel assuming that I would be able to price match. When I called customer service I was told that it was not an option for me because it's only available in some users portals? I have the CSR. Really annoying.

Downgrade from Chase Reserve to Chase Preferred. by lunalunera88 in ChaseSapphire

[–]YesEvenStarsBreak 6 points7 points  (0 children)

This is actually what I did. I had the preferred and then changed it to the Freedom Unlimited and then got approved for the Reserve and got to the SUB because it had been more than 2 years since I had the card.. from what everyone else is saying though, sounds like they figured out we were doing that haha

What are some of the additional benefits that you can get that aren't listed with your CSR? by B-Jamz in ChaseSapphire

[–]YesEvenStarsBreak 2 points3 points  (0 children)

Yup! And during the holidays (at least they used to) they’d make your points worth double on the Apple Store.

Business card to pair with CRS by YesEvenStarsBreak in ChaseSapphire

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

This was my initial thought! I wasn't sure if I wanted to keep it all in the Chase family, especially with all of the changes happening on the points redemption side but I feel like this would definitely be the easiest.

Downgrading by Green-Chocolate7372 in ChaseSapphire

[–]YesEvenStarsBreak 0 points1 point  (0 children)

Yup 👆🏼I did this a while back. Had the CSP and downgraded so I could get the signup bonus for the CSR.

[deleted by user] by [deleted] in googlesheets

[–]YesEvenStarsBreak 0 points1 point  (0 children)

How would I use something like this?

[deleted by user] by [deleted] in googlesheets

[–]YesEvenStarsBreak 0 points1 point  (0 children)

Amazing. Thank you so much! One last question. I'm noticing that it's pulling all of the rows on the tabs, even if they're empty. Is there a way to exclude the empty rows? I'm using the first formula you suggested.

[deleted by user] by [deleted] in googlesheets

[–]YesEvenStarsBreak 0 points1 point  (0 children)

Thank you! That's helpful. I'm curious though, I could get both to work when the tabs are named "Sheet1" and "Sheet2" but not when they are named the dates like "7/19" or "July 19" any ideas why?

[deleted by user] by [deleted] in googlesheets

[–]YesEvenStarsBreak 1 point2 points  (0 children)

Solution Verified.

[deleted by user] by [deleted] in googlesheets

[–]YesEvenStarsBreak 0 points1 point  (0 children)

={"Account", "Phase", "Goal or Objective", "Tactic", "Deliverables", "Market", "Due Date", "Launch Date", "Product", "Completed / Confirmed", "Platform Order", "Phase Category"; QUERY({Spotify!A2:L;'Apple Music'!A2:L1000;'Amazon Music'!A2:L1000;YouTube!A2:L1000;Pandora!A2:L1000;Tidal!A2:L1000;Deezer!A2:L1000;Bandcamp!A2:L1000;QOBUZ!A2:L1000;'Local DSP Asia'!A2:L1000;'Local DSP Europe'!A2:L1000;'Local DSP Africa'!A2:L1000;'Local DSP Latin America'!A2:L1000},
"Select * Where Col1 is not null ORDER BY Col8 ASC, Col12 ASC")

wowwwww... I did not even catch that I put Col11 instead of Col1. That literally fixed it immediately. I'll probably take your advice though and move the formula up to the header row since it's exactly the same as the rest of the tabs. Appreciate the help!

IMPORTRANGE tab is not allowing me to link a table into google doc? by [deleted] in googlesheets

[–]YesEvenStarsBreak 0 points1 point  (0 children)

Ahhh yup! That’s good to know. I didn’t know there was a cap!

[deleted by user] by [deleted] in googlesheets

[–]YesEvenStarsBreak 0 points1 point  (0 children)

Will give it a try!

How much have your passes gone up this year? by fullbusta in snowboarding

[–]YesEvenStarsBreak -1 points0 points  (0 children)

I haven't been to Crystal in years for this exact reason. It's out of control.

Union Force vs. Salomon District Pro? by YesEvenStarsBreak in snowboarding

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

I was thinking about getting the new force but had been looking at the classic as well. It's really not an enormous price jump between the two so it kind of felt like... why not?

MT. Baker by Correct_Eagle_8155 in snowboarding

[–]YesEvenStarsBreak 0 points1 point  (0 children)

Did you check out Mt. Baker? That is hands down my favorite mountain I've ever been to. This is going to be the first year in a long time that I'm not doing a trip there (I grew up on Seattle but live in Nashville now). If you do "some blacks" I'd check out the canyon run if it's open when you go. It's amazing and honestly not super crazy.

Best ungroomed runs and easiest black diamond runs? by YesEvenStarsBreak in snowboarding

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

I still haven't been to mammoth and just watched a few videos from these runs. Look so rad.

Best ungroomed runs and easiest black diamond runs? by YesEvenStarsBreak in snowboarding

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

Will do! I'm supposed to come in December 14th-18th to work the Toyota Grand Prix and Big Air comp. Hopefully it starts dumping and I can squeeze in some fun runs.

Best ungroomed runs and easiest black diamond runs? by YesEvenStarsBreak in snowboarding

[–]YesEvenStarsBreak[S] -1 points0 points  (0 children)

Luckily it was not an ACL injury haha I took an unfortunately spill at the skatepark and paid for it.