▲ 169 r/HololiveTCG
Nothing to see here
Needed some proxy purple cheers.... You can barely tell, right?
u/kiyachis — 9 days ago
▲ 31 r/PokemonTCG
Pokemon TCG Organization Labels - Free to Use!
Started working at a TCG shop recently, and they put me on bulk sorting duty (which has been a dream, if i'm being honest). Issue is I quickly realized at least half the workers couldn't tell yellow border set symbols apart, which made labeling and organizing bulk a nightmare. I started out by straight up drawing the symbols myself to make it easier for them, but after a while that gets.... tiring lol.
So I figured I'd make some labels!
Either way, not sure if anyone else has this problem, but the labels are done anyways, so why not make them available for everyone else! The Google Drive has two folders, one with the first version I made, which looked good until the inDesign frames and guides were turned off, and one with the "final" version, which looks a million times better.
The inDesign file is also in there, in case you want to move, substitute, add or remove any of the sets. Some are missing, some are MESSY (sorry Pop Series) but I did my best while trying to not waste space lol.
Ah, also! These are made specifically using the Avery Return Address Template (not sponsored, I wish), but I'm sure you can print them on any other label paper that has this specific layout.
Other than that, if you notice any mistakes, please let me know! Thanks!
u/kiyachis — 1 month ago
▲ 1 r/googlesheets
Conditional Formatting based on boolean-type information from another sheet.
Hopefully the image helps explain, but basically I have 2 sheets: One that tracks how many of a product our store has ordered from a specific distributor, and another that shows which distributors actually carry which brand.
Sheet 1 is used to make sure that we always have SOME product ordered, so anything with a 0 should stand out, but if the distributor doesn't carry the product to begin with, the cell will always be at 0. I would like to know if there is a way to reference Sheet 2 to make a conditional formatting rule so that all "null" cells (as in, cells where dist = no) would always be red or greyed out so that it is clear at a glance that those should be ignored (?) I hope that makes sense lol.
I tried something to the tune of "if brand = brand 1, then color = red" but i'd need to do that for every distributor, then for every brand, which would be like 20 different rules per column... surely there's a better way to do it?
Thanks!
u/kiyachis — 2 months ago