Is it possible to send an automated email that is FROM a contact email in a column?

We want to send an automated notification email to individuals in a contact column when a certain date is reached. Our problem is that they do not recognize the sender when it is from smartsheet. We would like it to send from a contact (their account manager's email) that is in another contact column in the sheet. Is this possible?

Answers