Auto-populate a cell based on column dropdown
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!
Comments
-
Hi,
How many contacts will there be approximate?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!