Sending cell information via email from a trigger

Joseph Farahat
Joseph Farahat ✭✭✭
edited 01/05/23 in Smartsheet Basics


For reference these assigned are unlicensed.

We use a sheet to assign staff to part time assignments.

We use the automation to send a form once a status field is changed to "can you work".

everything works great ..

Now I cant figure out how to send certain cell information from a row via an email.

Flow would be:

a) status changed to "mail now", triggers the information to be emailed to the assigned person.

b) that person acknowledges receipt of email which response populates another field on the sheet with a "got it"

The fields are already in the sheet.

Cant use an update request because it disappears from the email once acknowledged.

Thank You!!