I’ve created math columns representing rewards in golds and diamonds for my students. Once a user has answered a question, he/she will be rewarded automatically and it all set. My question is, is there any way around to make these columns zero golds and diamonds once they receive their rewards? other than deleting them on google sheet manually?
I would think there could be a “reward received” button that is tied an increment action, where that increment value is the negative amount of items received.
They are user specific. I reward them every two weeks then start over. I rather make it start over by itself by clicking on an option better than every two weeks I need to clean up the entries to start calculating.