Contact Formatted Cell --> Autopopulate Info into another cell.

How can I get a cell that is formatted as a Contact List to populate a cell to the right with a phone number, email, or other static attribute when a select different contacts?

Our assigned to items can change quite frequently, and it would be great to autocomplete contact info in the next cell automatically.

Thanks.

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

Andrée Starå

Hi,

How many different people can there be in the assigned to?

There are a few different options.

Add the information to a multi IF formula per each cell
Add the information together in one cell collected from a few so-called helper columns
Add a directory on the sheet or on another sheet that you can use to look up the information with the help of VLOOKUP or INDEX/MATCH.

Which method would you prefer?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic weekend & Happy Holidays!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

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.