How can I import/automate an alphabetical data set with two alphabetical column conditions ?
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!!!
Answers
-
You would use an INDEX/COLLECT along the lines of:
=INDEX(COLLECT({DMAs}, {County}, @cell = County@row, {State}, @cell = State@row), 1)
-
Thanks Paul, but I'm not sure how to execute this.....can you lend additional guidance since I'm new to Smartsheet?
-
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.
