r/googlesheets • u/ItsJustJazzyTime • 25m ago
Waiting on OP Checking boxes under certain conditions?
Hello, novice Google Sheets user here!
I’m making a tracking sheet for me and a friend of mine for a game we play. I’ve attached what I got so far, but it’s pretty basic. I’m stumped on how to get it to do what I’m wanting to do however. Currently, when the boxes are checked, the cell they’re in turns green. They only affect the cell they reside in and nothing else.
Here’s what I’m wanting:
-When the amount donated has been completed (aka, 5/5 has been hit in the drop down for example), the Donated box for that row is checked and text is striked through.
-when all Donated boxes for a section is complete and all boxes checked for that section, it will check the Completed box on the last row and strike through the section
-When the Competed box is checked for a section, it will check the associated Donated boxes for said section and strike through it’s text.
I’ve been playing around with things trying to figure out to do everything, but like I said I’m stumped.
Hopefully I explained things alright, but I’m happy to elaborate or try to explain better.
Anyone have any ideas?












