Auto-populate a cell based on column dropdown

mpincombe

Hello, and many thanks in advance for your help. I'm new to Smartsheet and spent some time looking through the various answers on this community forum and could not figure out the answer to this question. 

I've attached a screenshot of a smartsheet I've made. I added a section at the bottom of my sheet called Reference. My idea was to use this section of the sheet as reference material, and simply hide/lock those rows. 

Here's what I'd like to do: I'd like to auto-populate the column "AGWM Contacts" with whatever is in the "Ref AG contacts" for that particular country. In other words, whenever the country "Philippines" is selected in a row, the "AGWM Contacts" for that row would auto-populate with "mpincombe@gmail.com". 

Is this possible? Should I use the strategy of including a reference section at the bottom on my smartsheet, or include this reference table in another sheet (I've read you can now link/lookup from other sheets). 

Thank you!

Andrée Starå

Hi,

How many contacts will there be approximate?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

mpincombe

Hello!

I should have clarified: I won't be using the contact function for that column, rather I'll just be using a text column. I'd simply like the text copied automatically, which won't be more than 2 lines. Thanks so much!

Michelle

Andrée Starå

Ok.

Try something like this.

Change the ranges so that it matches yours.

=INDEX([Ref AG contacts]17:[Ref AG contacts]19; MATCH(Country@row; Country17:Country19; 0))

The same version but with the below changes for your and others convenience.

=INDEX([Ref AG contacts]17:[Ref AG contacts]19, MATCH(Country@row, Country17:Country19, 0))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Let me know if you have any questions!

Best,

Andrée