If checkbox marked, add name in a cell to a list.
Hello!
I am creating a wedding guest spreadsheet and I need some help. I am attempting to make it so that when a checkbox is filled (goes from FALSE to TRUE) then the name in the cell next to it get added to a list in a different column. Here’s an example (photos below):
If checkbox in cell D3 is filled then name in E3 (Lindsey) get added to the list in column P.
Then if checkbox in cell D 13 is filled the name in E13 (Sam - not in photo) gets added right until Lindsey in column P.
I want the names added as boxes are checked not necessarily in the order the list is already in. I hope that makes sense.
I’d like it so that if a box is checked the name they are added to the list.
Is this possible? If not, what the closest I can get?
If I need to do this on excel instead, I’m open to it.
[link] [comments]
Want to read more?
Check out the full article on the original site