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 "[email protected]".
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).
Help Article Resources
Check out the Formula Handbook template!