How can I import/automate an alphabetical data set with two alphabetical column conditions ?

Patti M

Hi all,

I'm new to Smartsheet and was hoping someone could help me.

2 alphabetic column conditions, County and State dictate a third- DMA or designated market area. I want the condition factors to auto populate a DMA column. How can I set this up? I have the raw data (County, State and corrsponding DMAs) in a separate Smartsheet Thanks in advance for the assistance!!!

Paul Newcome

You would use an INDEX/COLLECT along the lines of:

=INDEX(COLLECT({DMAs}, {County}, @cell = County@row, {State}, @cell = State@row), 1)

Patti M

Thanks Paul, but I'm not sure how to execute this.....can you lend additional guidance since I'm new to Smartsheet?

Paul Newcome

You would write out a formula with the above syntax creating each {Cross Sheet Reference} following the appropriate steps. If after reading through the below help article, you are still having challenges, fell free to post a screenshot of both the working sheet as well as the reference sheet.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references