We are using smartsheet for submissions for a point-based program we are running. When someone submits an item to the smartsheet through a form, they are awarded between 1-6 points based on what the item is that they submitted. Is there a formula I can use to count how many points someone has received so far, based on the email address they submit?
For example, Julia has 15 points so far. Is there a formula I can use that will total how many points Julia has?