Hi guys, first time posting so be kind I tried to do a search but came up empty on my specific issue, I'll try to describe it as best as I can.
For work, I created a spreadsheet that has 3 groups of approximately 7 items that can be check marked. I also added a "clear" button that removes all check boxes so we can start from scratch after each round. My issue is, I need to create 3 separate counters so that even after I hit "clear" the counter keeps going up whenever a specific group is used, and then a separate "clear" button for the counter itself (or some other means of resetting the counters to zero).
example:
1a
1b
1c
1d
2a
2b
2c
2d
3a
3b
3c
3d
Round 1:
If I check mark one or more items from group 1, the counter for it should go up by 1 (regardless of how many items are marked).
end result on the counter would be group 1 = 1, group 2 = 0, group 3 = 0
Round 2:
I check mark one or more from group 1, and check mark 1 or more from group 3 (regardless of how many items are marked)
end result on the counter would be group 1 = 2, group 2 = 0, group 3 = 1 (adding in the info from round 1)
at the end of the work day, I need a way for the counters to reset so on the next business day we start from scratch.
What kind of script would help me accomplish this?
EDIT: If it helps to have the script that I've created so far please let me know. I'll have to wait until tomorrow so I can give it to you exactly as is
Bookmarks