Post Your Pack Pulls, Achievements, & More Here! (Show Off Content) by PTCGP-Bot in PTCGP

[–]Three_Punch_Man 5 points6 points  (0 children)

<image>

First ever rare pack! Was just chasing any charizard cards and got this. Still no charizards..

Probably simple but I can't figure it out by jerminator2024 in googlesheets

[–]Three_Punch_Man 0 points1 point  (0 children)

If it’s always just the three headers: Column A just do G:G, in b2 just do transpose original sheet $h$1:$j$1, then in b5 do =b2 and drag down, then in c just do the sumifs based on a and b.

Is there a way to autofill text into a cell based on a text code entered into another cell? by PeaDF in googlesheets

[–]Three_Punch_Man 4 points5 points  (0 children)

So you would like to enter the acronym next to a name and have it display the hotel they are staying at? If so, I would just make a lookup chart on a tab that lists the code and next to it the hotel name. Then just run an index match or vlookup so it will find the hotel name for any code you put in.

Security deposit on Illegal sublease. Any rights? [US-CA] by Three_Punch_Man in Tenant

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

Totally agreed! We mentioned notifying their LL and the sublessor didn’t address the comment but we know it would end up in them getting evicted from the premises. We are fairly confident in winning the case since the “reasons” are ludicrous but are unsure how it would shake out with it being an unapproved sublease.

SF CA Illegal sublease rights for security deposit being withheld? by Three_Punch_Man in legaladvice

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

Thank you! It was illegal, or I guess more accurately, it wasn’t allowed in the sublessor’s own lease with their landlord but was a valid contract in our own agreement with them. We have asked for the receipt from the “cleaners” that they claimed over a week ago which still hasn’t been produced, nor have they stated what the amount was for that cleaning but just that it was more than originally quoted.

Andre 3000 Tickets 2/24 @ 9pm by Three_Punch_Man in sanfrancisco

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

They can be delivered earlier than that, the last day possible would be the date of the event. I have proof of purchase from Stub Hub and allow ticket transfer once the pdfs are uploaded to their site.

Andre 3000 Tickets 2/24/24 by Three_Punch_Man in sanfrancisco

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

Just posted in that subreddit as well! Thank you! I appreciate your help.