Hi all,

My company is hosting a game that will last for two weeks. There are 9 groups of 5, and each member of the group is tasked with an activity each day. If you complete the task, you get 1 point. Whichever team has the most amount of points by the end of the two weeks wins.

I'm trying to create a book that will show a pop up when opened each day. The pop up would say "did you perform today's task?" with a 'yes' and 'no' button. If they click yes, 1 point would be attributed to their team, which would feed into a formula living in a table in another sheet. If they click no, nothing would happen.

Here are my questions:
1. Is such a function possible to create without VBA? I don't have much experience with this.
2. This needs to be on a google doc. Is this sort of advanced function available on google sheet?
3. How would I go about making this customizable for each person/team? I wouldn't want one team to sabotage another.

Thank you!