u/mutantteacup_

I wanted more space on my ds so I copied my files onto an 8gb SD I had laying around after I used sdformat on it.

I added a few games (e.g. hotel dusk) which worked just fine.

Then I got some more, the new games i added after cant be opened for some reason. I tried downloading them elsewhere and it was the same, yet when I put the game on my old SD it shows up.

I only got YS on it yesterday so it should be the newest one, the games that didn't work were some lego ones and zelda ones.

I'm using an OG r4 revolution I was given when I was younger.

Is this micro SD not good?

I know that my Watch-pass should cover my plex home managed profiles (and it does) but for some reason I get this on my managed profiles ^^

I have tested with my friend and it seems to work ok thankfully and doesn't come up with the "Pay for watch-pass" pop-up, but it's a little odd and I'm unsure if it's a glitch or actually means anything.

I want to create a personal library spreadsheet. each type of item (e.g. Books, DVDS, Manga) is in a different sheet and so I have a total of 6 sheets, I don't have all my data in it yet but each sheet has a barcode/ISBN in the first column and a name/title in the second.

I want a search page where I can search using the barcode or the name of the item. I want the top 3 closest matches to display when something is typed into the search bar and if possible (but not necessary) have the name of what sheet that item is on displayed as well.

so when something is typed into the bar it should fill out the barcode, title and page name for the top 3 matches

I'm not sure what is possible cos I'm a major noob but if any specific part (or all) of this is not possible lmk.

here is a copy of my sheet: https://docs.google.com/spreadsheets/d/1cwyoxnG7O5kZTIpvX_smrjsgfoa3p6EGAsCib265uds/edit?usp=sharing

Edit: We have the search for just names working/searching across all sheets but for some reason it won't display anything with even numbers (e.g. when searching "maid" it will bring up Maid-sama vol 1 and 3 but not 2)
this was the function
=FILTER(VSTACK(MOVIES!B4:B, BOOKS!B4:B, COMICS!B4:B, MANGA!B4:B),ISNUMBER(SEARCH(F10,VSTACK(MOVIES!B4:B, BOOKS!B4:B, COMICS!B4:B, MANGA!B4:B))))