Assigna mail adress automaticly

Hi there ;

İ would like to get your advices about below issue ,

i have a column that i enter names ( colum name "Responsible") , near responsible column there is one column too (colum name "mail adresses" ) , is it possible that when i enter person name , mail adress will be written automaticly , these people that i add to column are not user of my account or smartsheet .

Find more posts tagged with

Sheets

Email Notifications

Accepted answers

Bassam Khalil

Hi @Automatic Mail

Hope you are fine, yes you can do that by creating a table in the same sheet or in new sheet contains 2 columns Name and Email then you can use a formula in any other sheet you need to collect the Email of each Name you enter automatically using functions like vlookup or Index with Match

All comments

Bassam Khalil

Hi @Automatic Mail

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.