I would like to email a volunteer that they have been approved for a position once I change their review status column to APPROVE. I would like to use a standard response.
I tried using automation…
<once row has changed>
when <x> column changes to <approved>and
<alert someone>
<send to contacts in a cell> then added the column name where the emails are stored
<send from triggering user>
<includes message only>
I also used unrestricted settings. For my test, I used my own row of data hoping the alert would be sent to the email specified in the <email> column on the worksheet next to my name.
The "alert" worked great but shows up in my smartsheets notifications rather than in my gmail - which is the email I have specified in the email column.
Since most of the volunteers are not smartsheet users, they will need an email sent to their email we have on file.
I thought perhaps I needed to have a different column with an email so I mocked up that but the automation did not recognize the column (did not show up as an option to check in the <send to contacts in a cell>)
Would it be different if I selected someone who did not have a smartsheets account or access to the underlying sheets or do I need to do something different?
Thank you.
