bradtrpchev Hi Brad!
Yes, it’s possible.
I’ll send an example below.
We have an internal process that utilizes a spreadsheet with a drop-down menu.
Whenever we update the status in a specific column, an email notification is sent to the reporter. Here is the spreadsheet with the drop-down menu:
In this case, we will use the “Reporter” column as tasks have been assigned. However, you can create a column to store the parents’ and administration’s email addresses.
In the subject, you can use the smart tags as the name of the student for example.
This article will help you to build a nice structure and message using smart tags.