I have a list of contacts with emails, and a column that indicates whether or not someone has completed an action. If that action changes to yes, I would like to notify only the person associated with that completed action, where their email is located within a column on their row. Is this possible?
For example, I have 15 rows of people, each with a unique email address. If John Doe completes an action, I want only John Doe to receive an automated email congratulating him on that action. There are also 14 other people who have not completed the same action, but when they do, an email should go out to the email associated with their record.
