Send email when email address is added to row

Andy Wilcock

I have tasks listed across rows and a person responsible for each task. What I'd like to do is, when I assign a person and put there email in a cell, they would be emailed alerting them of the assignment.

Is this possible?

Mike Wilday

You can use automation for this.

Set the automation to trigger when the assignee column changes.

Then you can send them either an update request or just a message indicating they have been assigned to a task.

https://help.smartsheet.com/learning-track/smartsheet-intermediate/automation

Mike Wilday

Just set the notify field on the action to the assignee column.