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?

Find more posts tagged with

Forms

Manufacturing

Formulas

IT & Operations

Cell linking

Email Notifications

Comments

Sheryl P

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.

Alex@

Thanks Sheryl, decided in the short term to manually add as a trigger

Alex

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.