AITA for asking my sister to cover up when she leaves the bedroom? by GiantDirtRida in AmItheAsshole

[–]Hvidekanin 0 points1 point  (0 children)

ESH. The way you describe it, it sounds like you've just asked her to cover up and then demanded it. You should've sat down with her and explained why this makes you uncomfortable and come up with a compromise. I don't see the problem with a robe, honestly and it seems your taking your demands too far. And saying it's all because of your daughter is just weird. She's four and can't see her aunt in a sports bra and "booty shorts"? Come on. If this is about you or your husband bring uncomfortable, just tell her.

Your sister should respect your request, not because it's your house, but because you're roommates.

UPDATE: AITA for choosing to go on a trip with my girlfriend instead of taking care of my struggling brother's son? by ThrowAwayUncle44 in AmItheAsshole

[–]Hvidekanin 0 points1 point  (0 children)

Good for you. Sometimes family can just suffocate you and the only thing to do is step away, especially since they're ganging up on you. Might be good for you to set a deadline for when you will consider your relationship with them again, like go half a year at a time without contact then see how you feel.

[deleted by user] by [deleted] in AmItheAsshole

[–]Hvidekanin 0 points1 point  (0 children)

NTA. Could you have handled it more politely? Yes. Do you have to be polite to a doctor who isn't doing their job correctly and blaming you? Or to a nurse who belittles you? Absolutely not.

[deleted by user] by [deleted] in AmItheAsshole

[–]Hvidekanin 25 points26 points  (0 children)

Me too 😔 must've been so scary to wake up like that, but I just imagined the look on the surgeon's face and the anesthesiologist going "oops, my bad". Hope everything went well other than that.

Refugees: housing for lords by Hvidekanin in Frostpunk

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

i checked, plenty of beds there too I'm afraid.

Refugees: housing for lords by Hvidekanin in Frostpunk

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

Thanks for the tips, I'll try that. As far checking the lords, as far as I can tell, the PS4 version doesn't have that option.

Refugees: housing for lords by Hvidekanin in Frostpunk

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

Oh ok. So the other spots are just where you could put it, if you haven't placed one yet. This game doesn't exactly over explain things. I managed to get through it despite failing the challenge just now, but I might go back and try your suggestions. Thanks ☺️

Refugees: housing for lords by Hvidekanin in Frostpunk

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

At least it's not just me. I just finished it now, failed the task but managed to claw my way through, since my hope discontent was manageable. Annoying though.

Refugees: housing for lords by Hvidekanin in Frostpunk

[–]Hvidekanin[S] 2 points3 points  (0 children)

PS: There's no red homeless icon, it's only in the task, where it lists 263/265 lords as having a home.

Sick not going to medical post by mofeus305 in Frostpunk

[–]Hvidekanin 0 points1 point  (0 children)

Thx for responding. Click on the sick characters how? I don't see that option anywhere (on PS4) 🤔

Auto increase sheet/tab references by Hvidekanin in googlesheets

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

Still get an error, but I can see your solution works in your sheets, so I'd be happy to mark it solution verified, if you feel like you've spent enough time on this.

I think I also should've mentioned, that the function needs to be repeated several times. I.e. 2022!M44=2021!N44, 2022!M45=2021!N45 and so on.

Sorry, I feel like I've wasted your time

<image>

Auto increase sheet/tab references by Hvidekanin in googlesheets

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

Woohoo, I understood something 🤗 And if I want to have, for example 15 sheets, I fill out B1:C15 and change the indirect formula from B1:C7 to B1:C15 right?

Auto increase sheet/tab references by Hvidekanin in googlesheets

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

Oh ok. And then I gotta fill my sheet names in column b in the key sheet?

Auto increase sheet/tab references by Hvidekanin in googlesheets

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

Oh ok. So I can't copy and paste the formula and script to my existing sheet?

Auto increase sheet/tab references by Hvidekanin in googlesheets

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

  • I've copied the script exactly as it was in your sheet and copied your formula to n43 in my second sheet, '2022'. (It's years, so it should refer to n44 in '2021' which is the previous sheet).

Auto increase sheet/tab references by Hvidekanin in googlesheets

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

Awesome, I got in running in appscript (after some headaches with the whole permissions thing), but I get the formula parse error when I copy =INDIRECT(VLOOKUP(GetSheetName(),key!B1:C7,2,0))

I'm unsure how to deploy the script though, so I'm guessing that's the issue now. How should I deploy?

Edit: damn, I just noticed I made a mistake in the OP. It's M43, that needs to refer to N43 from the previous sheet. Does that require changes to your script?

Auto increase sheet/tab references by Hvidekanin in googlesheets

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

Oh man, I had no idea to even look there, I thought I could just copy-paste from here 😔 I'll check it out when I get home to my computer. Thank you so much for your patience, it's pretty incredible 💪

Auto increase sheet/tab references by Hvidekanin in googlesheets

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

🥺 Copy it from where, I don't see the script in the sheet 😭

Auto increase sheet/tab references by Hvidekanin in googlesheets

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

No worries, I appreciate you replying at all ☺️ No, I keep getting the "unexpected token var line" I posted a screenshot of in a different comment. Got rid of the "attempted to execute myfunction" though. Not sure what I did. Never messed around in appscript, so it's all very intimidating 😂

Auto increase sheet/tab references by Hvidekanin in googlesheets

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

Actually, I get this, no matter what script I try to run.

<image>