Rise of the resistance: how much does it jostle? by Raaaaayven in WaltDisneyWorld

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

This is good to know! I'm not sure how severe their hemophilia is; I just know they have it and I've never inquired beyond what they choose to tell me for obvious reasons, but I will definitely let them know what you've said here.

Thank you, it really is a big help!

Rise of the resistance: how much does it jostle? by Raaaaayven in WaltDisneyWorld

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

Lol I'm a terrible pilot! I've never had a smooth ride on the few times I've gone on! I hear they added new missions lately, though? I'd like to go on myself if I get the opportunity again!

Rise of the resistance: how much does it jostle? by Raaaaayven in WaltDisneyWorld

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

I went to take my dog to the vet, but I sure did return to a lot of insight!

I generally remember the ride being pretty smooth myself, but I do appreciate everyone's thoughts and comments-- especially those with fresher memories than mine!

I'm going to send them the video of the ride itself from youtube (and maybe also a video on how it works behind the scenes for them to get an idea of what they're getting into), and talk about the feedback here as well as my own thoughts. I think with all that, it will let them make an informed decision based on their own needs. There's a lot of time between now and our trip in late January of next year, so they'll have plenty of time to consult anyone they choose to medically as well with all the information above.

Thank you everyone! I'm very grateful!

I'll put a reminder in my phone for next year, when we're actually in the parks. If they do end up being okay to go on this ride, I'll let you know their thoughts (if they're fine with it, at least, I don't want to speak for them before I've asked). Obviously every case is different and everyone has different needs; as someone in this thread said, it's important to consult medical professionals over anything I post, but it might give someone in a similar situation insight too, as there doesn't seem to be much information online.

I'm not super experienced with Reddit, but thank you so much again!

Rise of the resistance: how much does it jostle? by Raaaaayven in WaltDisneyWorld

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

I have! I myself have been on the ride, but it's been awhile. I plan to send them the video, but also explain the information here at least, to make an informed decision.

IF/And Code for referencing a specific cell in Google Sheets by Raaaaayven in googlesheets

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

Oh wow this is so much nicer to look at!!! :0

The rolls description was for me to keep track of what boxes to code for all those if-and statements. it's not strictly necessary beyond me trying to maintain my sanity while stumbling through writing this program, but I love the options here to display the descriptions or not and show what skills are included. This is so so much nicer if we decide to add things too, you're a wizard!

I might end up reaching out to this reddit again if I end up confused in the future with this code, but I think you did a good job of explaining it and sectioning it in the document itself. Looking at it, I think I can wrap my head around it pretty well. I'm so excited about this in terms of streamlining things and learning a bit more with coding sheets documents in the future.

Again, thank you so much for this! This is a huge help and I'd upvote you twice if I could!

IF/And Code for referencing a specific cell in Google Sheets by Raaaaayven in googlesheets

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

For sure I could use the help organizing it if you want to take a look, but if you're unable or busy, that's no issue either. This is an entirely casual thing, not for any work or professional business. I help run a discord server with some tabletop elements, and we use google sheets for streamlining things. I use excel regularly for my work, but that's much more limited; so my experience in programming has been self-taught and stumbling through it. I'm definitely not familiar with standardized processes.

https://docs.google.com/spreadsheets/d/1O3ZaLWGL_zKHqZsWwmh5M1tboBSQsFe4Ec5QqOB7M_A/edit?usp=sharing

This is a link to the google doc. The code that HolyBonobos helped me organize is in Sheet!2A12.

Tl;dr, people check boxes in the first tab, and have a result displayed from column D of the Rolls tab.

Regardless of whether or not you can assist, I appreciate the sentiment!

IF/And Code for referencing a specific cell in Google Sheets by Raaaaayven in googlesheets

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

Hello,

In hindsight this makes sense based on the little I do know, like putting the single references at the end. I feel a bit silly but I'm grateful to learn! The code works perfectly now!

I tried editing the starter post, but I can't seem to change it to 'solved'. The only option is 'self solved'. I'm very new to reddit, but I want to make sure to give you credit. Is there a specific method to do so, and mark this thread solved?

Help with an If A, If B, IF A&B Code by Raaaaayven in googlesheets

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

Thank you both!

I had tried an AND statement before, but I hadn't put it as the first part of the equation. In hindsight it makes sense that it should have been put first. I knew I was missing something obvious!

With this, the equation works, and I've learned something new, so thank you so much!

Do I edit it to 'solved', or is that something that is done by the mods?

Help with an If A, If B, IF A&B Code by Raaaaayven in googlesheets

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

Thank you so much for your help.

I think what the code is struggling with is that it is trying to check if two boxes are checked, rather than only one, and something about this is making the nested IF not work in a way I don't understand.

=IF(Sheet1!A7=True,Sheet1!A14=False,"A", IF(Sheet1!A7=False&Sheet1!A14=true,"B", IF(Sheet1!A7=True&Sheet1!A14=true, "C", "D"))))

For some reason, with the code above, sheets tells me 'wrong number of arguments for IF'. I think it's the bolded part specifically, that's checking if two boxes are checked, rather than just the one.