u/knyexar

Bonjour, je vais passer une demi-journée à avignon aujourd'hui, est ce que quelqu'un aurait des recommandation de choses a voir/faire et ou manger ce midi?

Hi everyone, I'm trying to make a sheet to track some stuff for a game, and among those id like to have a timer on one cell that counts down how much time left until the next Sunday midnight UTC and then resets itself at midnight to start counting down for the next week.

Is there a way for Google sheets to do that or do I just gotta manually reset it weekly

So, I'm trying to make an automated sheet for a pokémon-related thing.

One sheet has every pokémon listed by name and lists all their stats and abilities (for example cell A2 says "bulbasaur" and cell A3 says "1" because that's its number in the pokédex)

What I'm trying to do is make it so on a second sheet if you type in "bulbasaur" in a dedicated cell, then a second cell automatically gets filled in with bulbasaur's health, a second gets filled with bulbasaur's attack etc... Is there a way to do this?

The only way I know of to do something similar is using if statements but due to there being 1000+ of these things that's clearly not a viable solution.