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

MATAYLOR

 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?

Paul Newcome

Are you able to provide some screenshots with mock data for context?

MATAYLOR

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

Paul Newcome

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.

MATAYLOR

Hi Paul

thanks for helping , could you give me an example please as i can seam to get index,match to do anything