Google Sheets glitches

I can fake working on spreadsheets and Google Sheets files in particular to account for the cards in my various collections - it makes me feel good to feel like I'm curating and cataloging all sort of cards in the files I've created, but maybe I'm doing something wrong.

As I'm trying to list out my last 'runs' of awesome action collecting topics subset adds for the year - I've discovered numerous instances where either Google Sheets or 'user error' is causing the information I've added to cells [to further classify cards in my Google Sheets file] to be displaced or disappear entirely.

There maybe instances where information is added in the right place where my 'batting' cards are grouped as such - but why do I find instances where the 'batting' tag is under subsets, when they should be grouping tags.

Bear with me, but everything listed under the subset column should be under the grouping column - I don't know if I'm putting the information in the wrong place all this time, but I feel like there are gremlins messing around with my Google Sheets file.

It maybe a case where the file is bloated with all sorts of entries from at least 15 years ago- so when I try to load the file, it lags and somehow jumbles things up.

What I've resorted to doing is seeing if I can copy over the main file and see if the apparent mess ups show there - I'd really like to see if I can just work on adding to a previous version where I feel like things are intact [through a certain point].

The nuclear option was to create new related files for a fresh start - even if it means breaking up the bulk of the listings of different mini-collections under my 'awesome action' umbrella.

I hope using separate files will be easier to look at and add listings of cards into without the worry about mushrooming file size - but it maybe a case where the transition will begin some time in 2022.

collecting topics - AA - pitching - 12-6-21

collecting topics - AA - fun - game - personality - 12-6-21

collecting topics - AA - unique perspectives - 12-6-21

collecting topics - AA - fielding - 12-6-21

collecting topics - AA - batting and baserunning - 12-6-21

collecting topics - AA - celebrations - confrontations - curtain calls - 12-7-21

collecting topics - AA - strictly other sports - 12-7-21

Another screen shot of a Google Sheets file

As far as I know, I've mostly gotten specific cards from my awesome action collection jammed together - it may have been the only thing I've thought about as far as collecting cards go.

I added a column to the Google Sheets file where I could 'tag' listed cards I had in-hand according to a sport - I'm always a 'baseball first' guy, but I want to account for cards from basketball, football, hockey, etc.

As far as cards from other sports, I'll have cards I'll physically add to the end of specific classifications / groupings that were made for my baseball collection - but there will also be a stand alone collection of cards for each sport.

Basketball - actual on court action - in the air; stick this with my baseball ‘in the air’ collection

Football - skill players - quarterbacks, receivers, running backs, tight ends

Football - special teams - running backs, defensive backs

Football - offense - kickers, linemen

Football - defense - cornerbacks, linebackers, linemen, safeties

Football - unique perspectives - celebrations

Hockey - actual on ice game action

Hockey - unique perspectives - celebrations, photo ops

Classifications / groupings for my stand alone cards may be just a little different from my baseball ones - I was trying to think of some unique themes for the football cards, but stuck with trying to arrange them by position.

Awesome action projects - classifications and groupings

I'm all about trying to stretch my interests out as far as playing with my cards and off what I'd started last year, there has been a push towards trying to see where specific cards off my awesome action collection can be jammed together - for the longest time, my awesome action collection was a mashup of assorted cards, but maybe I've been influenced by other cards bloggers to get even more specific as far as pooling together cards that show similar, unique images.

I added a column to the Google Sheets file where I could 'tag' listed cards I had in-hand according to a classification - I might have around 1,000 cards listed in my main awesome action collection and so I don't get overwhelmed, I'm only grabbing a certain number of cards at a time [like all the cards of players with the last names A-B, B-C, etc] to get through the year.

To dig a little deeper perhaps, I added a grouping column where I want to label cards within the main awesome action subset and classification - so far, I only have my A-B cards off my main collection and awesome action cards I had in my temporary setups to classify.

I’ve tried to conjure up groupings that come up as I’ve played and listed out cards in a specific classification - as is, it was a little confusing to sort what I had all over again, going in different directions, trying to herd into one place, that might fit better in another place, etc.

I worry the names of the groupings sound too basic, where there isn’t really have a ‘bite,’ but the cards that are tagged under an occasional boring sounding grouping - were collected within the awesome action umbrella.

Actual on field game action - baserunning, batters bunting, batting, celebrations, confrontations, curtain calls, fielding, in the air, making the throws and pitching.

Dirt fetish - maybe not as specific as long as I see dirt

Fun cards - goofing off, gum cards, having fun, mascots, mugging it up, oddities and props

Game face cards - focused, men at work

Personality shots - fired up, tributes

Unique perspectives - angles, event captured, horizontal, interviews, lounging around, majestic / panoramic, multiple-exposure manipulation, posed photo shoots and signage.

Maybe by the end of the week, things got more clear cut - where I was able to organize by classification and grouping, though it is just the start.