Share score with person that completed quiz

So I have all my formulas set to calculate the score on an 8-question quiz.

Is there a way to automatically share the score with the participant once they submit their answers?


  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Hi @jmendoza555

    You can do this with automation, you'd just need a contact column on your sheet with an email address.

    If you had a sheet similar to the below (your score calculation formulas in the Score 1-8 columns):

    You can then set up some automation similar to the below:

    Which would then send the person an email message/notification:

    If you didn't want to do a breakdown by question you can customise the message to just give them the total etc.

    Hope this is clear enough to get you started, but if you've more questions then just ask! 😊

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!