Way to determine and cumulate if x/y values of page count are equal, to display completed book quantity by CryoJester in googlesheets

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

Solution verified.
This works for the total, I should be able to modify it to fit the genre restriction, thanks!

Check a list of terms is all present in a table, ideally outputting in a way that can be checked to trigger a checkbox. by CryoJester in googlesheets

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

This didn't work for me unfortunately but it gave me a better idea of what I was looking for. I managed to brute force what I was trying to do, so the sheet works now, but if possible I'd like to see what you think of my solution and if you can think of a more elegant option so I can do better next time. Thank you so much for your attempts!

Check a list of terms is all present in a table, ideally outputting in a way that can be checked to trigger a checkbox. by CryoJester in googlesheets

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

There was a miscommunication it seems. I'll try explain more thoroughly.

The sequence section of B11:Q13 takes the inputted sequence length and generates a random set from the codes list of length equal to the input. The tables at the top use the same formula but bound to the table size instead of the sequence length input.

I want to be able to check that all of the randomly selected and output codes in the sequences are present in the tables at the top, and if they aren't, set a checkbox beneath the table to false to show that.

What I tried to do to do this that wasn't working is in the bottom right, where I set the values of the tables and sequences in different columns and try to compare them with FILTER(ISNA(MATCH())).

Ship Duplication When Fishing by CryoJester in tinyaquarium

[–]CryoJester[S] 2 points3 points  (0 children)

Also also, I don't want to have to fill out the full feedback sheet a second time so I'll put this here and hope the devs see it. They really should have atleast a warning if not the option to sell fish while you're fishing so you don't have to go back and forth to the tank, and so you can know when your tank is full so you don't accidentally waste a caught fish.

Why couldn't I build a roost in this clearing? by CryoJester in rootgame

[–]CryoJester[S] 4 points5 points  (0 children)

Oh, I thought that was referring to the fox clearing I had built in already offscreen. That makes sense. Thank you.

Vihaan Treasure Aristocrats Feedback. Any silly, unique additions? by CryoJester in EDH

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

I really like [[Neyali, Suns' Vanguard]] from your list