Previous post marked closed due to being unfocused, so I pared it down. Not sure if this is now good enough, if not please can someone comment to explain so I can correct it?
I'm trying to find a way to do the following in Google Sheets, but cant find anything similar after googling and browsing forums. Imagine a sheet that will end up with about 200 rows lets say, and 4 columns. Column A will have a static value (the name of a game) in each row, and different users at different times will add rows, and fill in the name of a game into Column A. Columns B, C, D represent something like "Want to Play", "Own", "Willing to Teach" and other users would then add their names to those columns to indicate interest or willingness to teach that game. This would be an ongoing process ("living document") where users will periodically add rows, update the games they own, are interested in, etc. Because its a lot of rows, and there will be multiple names already in the B, C, and D column cells, double clicking into each cell, getting the cursor into position and typing out your name would be so onerous as to scrap the idea. Below is a type of solution I sketched out, but not sure whether or how it can be executed:
3 checkboxes on each row next to the game, one for "Want to Play", "Own", and "Willing to Teach. and then a separate area with users names and a checkbox next to each name. You could check the box next to your name, and then go down the rows, selecting checkboxes within each row corresponding to the column you want your name to insert into. Once done, click a button to execute, so it would insert your name into cells based on the checkboxes you ticked. Is this doable? If so, can someone give me some tips on the types of formulas and approach I'd need to take?
Here is an example screenshot of roughly what it could look like:
