Auto-populate a cell based on column dropdown

mpincombe
mpincombe
edited 12/09/19 in Formulas and Functions

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!

screenshot.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!