am trying to create a sheet that can autopopulate two columns based on the information put into ano

am trying to create a sheet that can autopopulate two columns based on the information put into another...
For instance...
· column A will have text (site address)
· column B needs to populate... (contacts name)...column b is a contact list, which would then have a automation to alert the person in that cell.
Does this make sense? Can this be done in smartsheets?
Answers
-
Are you able to provide some screenshots with mock data for context?
-
Hi Paul
so ether the sold to column or the region column,
EG if region is bridgend them contact would be Marc taylor for example or if region column was tamworth then it would leah
-
If you only have a couple of different regions, then you can use a nested IF statement, but if you have more than a few then I would suggest creating a table where the regions are listed out in one column and the contact in another. Then you can use an INDEX/MATCH to pull in the appropriate contact based on the region.
-
Hi Paul
thanks for helping , could you give me an example please as i can seam to get index,match to do anything
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!