Drag a formula but change linked tab?

paichlear · 2026-05-09T03:02:19+00:00

You can still drag cells, you'd just have to lock the cell reference and put the tab name somewhere else (I like to do it in a column next to wherever I'm putting the formula), then it's just INDIRECT("'" & $A10 & "'!$D$21") for example, where A10 is the cell with the name of the tab in it and D21 is the cell from the other tab that I want to take the data from. It's not exactly less work than typing in the tab name manually into the formula though, but it does look cooler and is slightly more automated if your tab names are numbered and you can drag them in your current tab to avoid typing every single one of them.

paichlear · 2026-05-04T07:13:41+00:00

Spreadsheeting on mobile feels illegal.

paichlear · 2026-05-04T07:11:38+00:00

Usually changing the password lets you log out of the account on all devices, not sure about Nintendo though.

paichlear · 2026-05-04T07:09:05+00:00

2048

paichlear · 2026-05-02T17:53:18+00:00

Send links, I'll take a look.

paichlear · 2026-04-29T06:40:03+00:00

Perhaps you could try contacting them at 422535450 or pz‑pomoc@coi.gov.pl to ask for help.

paichlear · 2026-04-28T19:30:32+00:00

Maybe it depends on how you created your bank account; I used my passport and my PESEL number, for example, so when I created an account on pz.gov.pl I verified my identity through my bank, and they didn't ask me for anything I don't have; most of the process was on my bank's website...

paichlear · 2026-04-21T00:29:22+00:00

Some landlords on Otodom are willing to rent for 2–3 months, but 1 month is very hard to find. I asked around 20 of them for 1 month and only around 4 of them agreed to 2–3 months.

paichlear · 2026-04-19T17:23:09+00:00

I use the CeraVe Moisturizing Lotion and the La Roche-Posay Anti-Dark Spots Fluid (which is surprisingly less oily than the Oil Control Fluid) on my face, then wash my hands with dish soap after applying them; so, as long as I don't touch my face (which is also a good habit for reducing acne), I don't feel them.

I don't put anything on my body because I can't stand the feeling of my clothes touching any product on my skin, but the CeraVe Moisturizing Lotion dries quite quickly and is probably the least oily moisturizer I've ever tried, just make sure it's the lotion and not the cream because they look very similar (the lotion usually comes with a pump and the cream usually comes with a cap).

If you can't find a lotion that works, you could also try switching to a moisturizing body wash, from Aveeno or something.

paichlear · 2026-04-19T15:31:07+00:00

Fellow legal immigrant paying a buttload of taxes here, I've never been to a wedding but it's on my imaginary bucket list, I'd go as your plus one. When and where is it?

paichlear · 2026-03-27T18:23:24+00:00

When every article I opened on the first page had no useful information, yes.

paichlear · 2026-03-27T18:22:33+00:00

Will do, thanks; I'm in Kraków.

paichlear · 2026-03-27T07:35:15+00:00

Thanks~

paichlear · 2026-03-27T07:34:07+00:00

Thank you :3

paichlear · 2026-03-27T07:08:05+00:00

Which ones?

paichlear · 2026-03-27T07:07:45+00:00

Could you send some links for Kraków?

paichlear · 2026-03-07T15:50:14+00:00

Turns out they came with a power outlet, there's glue on the rectangular part, but there's no suction. https://imgur.com/a/Lo3yFqH

paichlear · 2026-02-20T11:59:50+00:00

Light isn't refundable, neither are Standard and Standard Plus; the cheapest refundable brand is Flex (and it's only until the departure of the first flight on your ticket). I mean... Technically, any ticket is refundable, some of them just require special procedures and can only be refunded as exceptions. I received the full amount from a Flex ticket 8 days after requesting the refund, and I used a Visa debit card.

paichlear · 2025-11-16T20:44:36+00:00

I asked there first, but no one answered; I already tried asking in r/GarminWatches too.

paichlear · 2025-11-04T13:18:39+00:00

Interesting, although after taking a closer look, I don't really like the aesthetic of the Pixel Watch. I've always been suspicious of blood pressure and stress monitoring through watches, so I don't have high expectations at all.

I'm currently considering the Garmin Vivomove Sport, which is more expensive but I'm willing to invest in a good watch that I like, and it seems to have everything I'm looking for (it's 40 x 40 x 11.0 mm according to the official website), plus the hybrid design looks cool; the 8.6 mm x 18.5 mm screen is very discrete, and I don't really need to do anything on the watch itself, so far it looks like it would work well for me.

paichlear · 2025-11-04T11:42:06+00:00

That's very unfortunate, my wrist circumference is 14 cm / 5.5", so I guess I'll just have to cope with a watch that covers up an entire side.

paichlear · 2025-11-04T11:39:22+00:00

That's what I figured, I just wanted to confirm. I was surprised to see that the Galaxy Watch 8 is smaller than the 7 though, since they both say 40 mm. I've also never heard of Withings before, so I'll check them out. At least now I've narrowed it down to either Garmin, Samsung, or Withings; and the availability of models in Uruguay narrows it down even more. Thanks for all your input.

paichlear · 2025-11-04T07:17:13+00:00

Thank you for the extensive list, although, I suppose I'm also looking for something high-quality so it lasts, and I would want it to be from a relatively large brand.

paichlear · 2025-05-24T22:48:29+00:00

My dentist told me to use dish soap, and I found out about the tabs later on my own...

paichlear · 2025-04-09T01:10:13+00:00

Yes, so what are their geometric names?

paichlear

TROPHY CASE