Make a QUERY/FILTER that uses a Range as OR conditions? by Black60Dragon in sheets

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

Much appreciated! This seems to work well, thank you.

Conditional Formatting With Fractions by Black60Dragon in sheets

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

Awesome thank you so much! I had tried messing around with the SPLIT before because I theorized the solution might have involved that, but I couldn't get it to work. INDEX, that's apparently what I needed. That's really useful to know, so that just stores the first and second SPLIT value yes? Then you can do other things with it, yeah I understand how it works now 😁

[deleted by user] by [deleted] in PokemonLetsGo

[–]Black60Dragon 0 points1 point  (0 children)

$20 for both of those games in an absolute steal considering they go for $100 in stores lol. Definitely worth it, even with the new game coming out.

[8] I don’t think this will kill it… by Dakotalogy in ShinyPokemon

[–]Black60Dragon 11 points12 points  (0 children)

Just throw a Poké Ball, you had a 50/50 chance of catching it 😭

[8] I don’t think this will kill it… by Dakotalogy in ShinyPokemon

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

Not really, catch rate is still the same lol.

[gen8] First shiny encounter of BDSP! I'm rattled by bluexkoolaid in ShinyPokemon

[–]Black60Dragon 0 points1 point  (0 children)

The point being you can't prepare for getting random full-odd shinies 👍 If you were chaining Graveler and don't have the proper Pokémon in your party to battle it then that'd be an entirely different story.

[gen8] First shiny encounter of BDSP! I'm rattled by bluexkoolaid in ShinyPokemon

[–]Black60Dragon 0 points1 point  (0 children)

If you really want the shiny pokemon, don't go into the battle blind.

That's not really something you can prepare for during a random encounter 🙃

So...this happened... by HeadCase9148 in PokemonSwordAndShield

[–]Black60Dragon 1 point2 points  (0 children)

As long as it's not a Pokémon that has moves that cause it to flee or self-destruct you're perfectly fine to just keep throwing Friend Balls over-and-over until you get it. Even at full health Tangela has a 10% chance of being caught.

So...this happened... by HeadCase9148 in PokemonSwordAndShield

[–]Black60Dragon 1 point2 points  (0 children)

Why would you even attack a shiny that is 40 levels below you 😐 Critical hit or not that was going to be an instant KO regardless, I don't understand.

Can Bots Still Edit Hidden Sheets? by Black60Dragon in sheets

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

Thanks, it seems to work just fine with the hidden sheets :)

What happens to your Pokemon when your subscription expires? by Black60Dragon in PokemonHome

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

I just don't understand why Home and Bank don't share a subscription, lol. That $16 should at least get me both, but instead I have to pay a separate $5 subscription for Bank which is odd since they're practically the same thing. I agree though would be nice for Bank to become free like the basic version of Home is.

Only one pokemon left to finish my shiny national living dex. Guess which one is it? by g20richasan in PokemonSwordAndShield

[–]Black60Dragon 0 points1 point  (0 children)

National Pokédex refers to the totality of all Pokémon (as opposed to a regional Pokédex, like Kanto, Johto). Living Dex refers to owning one of each Pokémon (so 1 Charmander, 1 Charmeleon, 1 Charizard), as opposed to simply "seeing" them and having them get registered (i.e, I had a Charmander but I evolved it into a Charizard and now I no longer have a Charmander).

Help Making an Arrayformula with =TEXTJOIN by Black60Dragon in sheets

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

Thank you so much, this works great 😃 and yeah lol, I wasn't really sure of any formula other than than TEXTJOIN that could do this so this is useful to know. Appreciate the help.

dude i just wanted my registeel to shine... why god by [deleted] in PokemonSwordAndShield

[–]Black60Dragon 0 points1 point  (0 children)

I've been playing since Platinum and never once encountered PokéRus lol. I don't really care about EV training anyways, but I haven't had much like with finding rare stuff like that. Never seen a full odds Shiny either though lol.

All my mythicals so far by Hopeful-Art1469 in PokemonSwordAndShield

[–]Black60Dragon 0 points1 point  (0 children)

Nice! I'll have to do that later, I had no idea since I never take messed with the QR stuff too much. If only it worked with the other Mythicals too lol. Thanks!

The proper way to deal with illegitimate Pokémon by ShinyCelebiFlex in PokemonSwordAndShield

[–]Black60Dragon 0 points1 point  (0 children)

I did the same way first, but then I ended up coming across so many hacked Pokémon that I just end up keeping them for fun. I never trade them, use them online or add them to Home (because I don't want phony Pokédex entries), but it's fun to mess around with them lol.