E-mail notifications
Hi,
I have a 'Sheet' named 'Main sheet' with forms submissions arriving all the time, within the 'Main sheet' there is a field called 'Employee Department', when populated from the form this looks up the 'Project Sponsor' from a further 'Sheet' named 'Lookup' and pulls the e-mail through to the 'Main sheet' - this all works fine. However when this lookup is complete I would like to trigger an e-mail to send to that 'Project Sponsor' e-mail address automatically - 'Sends to contacts in a cell' would work but the column will not let me change to a 'Contact list...' ....any ideas?
Comments
-
Can you use the trigger "email" on main sheet to trigger email. Sounds like it starts blank, the lookup occurs, then not blank - so trigger alert to email (now populated) on Main Sheet.
-
Thanks Sheryl, decided in the short term to manually add as a trigger
Alex
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!