E-mail notifications

Alex@
Alex@ ✭✭✭
edited 12/09/19 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!