Automated email to Contact in a Cell
![Vuckecucke](https://us.v-cdn.net/6031209/uploads/userpics/GI2P9DLOKRZ2/nHMPOCQMDSZKH.jpg)
Hello,
Is there a workaround to send an automated email (box check) to a contact in a cell, but its not a contact column, rather than a formula column? many thanks!
Best Answer
-
Thanks @Gia Thinh!
This formula worked: email address@row
Here is the set up. All 3 colums are the same users. My goal for any sheet is to reduce the # of colums. thanks!
Answers
-
Hi @Vuckecucke
To send an automated email to a contact in a cell, the cell must be part of a contact column.
As a workaround, you can add a helper column named "Contact" and use the following formula:
=Email@row
This will convert the email address into a contact format, allowing automated emails to be sent.
Hope it works for you.
Gia Thinh Technology - Smartsheet Solution Partner.
Email : thinh.huynh@giathinh.tech -
although i am trying to reduce the # of columns, this is helpful. thank you @Gia Thinh
-
actually, this formula does not work.
-
Can you share a screenshot of the sheet showing the formula?
Gia Thinh Technology - Smartsheet Solution Partner.
Email : thinh.huynh@giathinh.tech -
Thanks @Gia Thinh!
This formula worked: email address@row
Here is the set up. All 3 colums are the same users. My goal for any sheet is to reduce the # of colums. thanks!
-
Good!!
Gia Thinh Technology - Smartsheet Solution Partner.
Email : thinh.huynh@giathinh.tech -
thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives