# Multiple choice and import data form another sheet
**URL:** https://community.glideapps.com/t/multiple-choice-and-import-data-form-another-sheet/23410
**Category:** Ask for Help
**Created:** [February 25, 2021, 6:38am UTC](https://community.glideapps.com/t/multiple-choice-and-import-data-form-another-sheet/23410 "2021-02-25T06:38:54Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Luis\_Siles](https://community.glideapps.com/u/Luis_Siles)
#### Post date: [February 25, 2021, 6:38am UTC](https://community.glideapps.com/t/multiple-choice-and-import-data-form-another-sheet/23410/1 "2021-02-25T06:38:54Z")
I have a problem:
this is my first choice list **"constructora"**
and this is the second choice list **“proyecto”** , depends on the first list
now, I have to create on a third sheet,
with **“constructor”** and **“project”** options but in this part the column relation type does not work, so the second list depends on the first list.
How can i fix this ?.
I also need to import data from another sheet to new third sheet,
for example, click on ¨ + ¨ to create a new row in the third sheet but I already have some data in another sheet and I want to import it here so as not to repeat
How can I do that?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 25, 2021, 8:34am UTC](https://community.glideapps.com/t/multiple-choice-and-import-data-form-another-sheet/23410/2 "2021-02-25T08:34:34Z")
In your proyecto choice component, I believe you can use a filter like this:
Constructora is **Screen’s** Constructura.
It will be filtered by your choice of constructora in the first component, and hide the second choice component until the first is not empty.
---
### Author:  [@Luis\_Siles](https://community.glideapps.com/u/Luis_Siles)
#### Post date: [February 25, 2021, 1:03pm UTC](https://community.glideapps.com/t/multiple-choice-and-import-data-form-another-sheet/23410/3 "2021-02-25T13:03:04Z")
Yes, but is not a problem. The problem is if select AAA in the first choice, the second choice only the show result to AAA, which in this example the result to second choice is 111,222,333
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 25, 2021, 2:03pm UTC](https://community.glideapps.com/t/multiple-choice-and-import-data-form-another-sheet/23410/4 "2021-02-25T14:03:12Z")
Can you show a screenshot of your proyecto choice component filter setting? Like @ThinhDinh said, if you filter by Screen Value of fthe first choice component, then it will only give you the proyecto options that match the chosen constructors.
---
### Author:  [@Luis\_Siles](https://community.glideapps.com/u/Luis_Siles)
#### Post date: [February 25, 2021, 7:53pm UTC](https://community.glideapps.com/t/multiple-choice-and-import-data-form-another-sheet/23410/5 "2021-02-25T19:53:05Z")
thanks, it’s worked
---
### Author:  [@Luis\_Siles](https://community.glideapps.com/u/Luis_Siles)
#### Post date: [February 25, 2021, 7:53pm UTC](https://community.glideapps.com/t/multiple-choice-and-import-data-form-another-sheet/23410/6 "2021-02-25T19:53:32Z")
thanks for clarifying, it’s workwed.
NOw for that import data from another sheet to new sheet,
for example, click on ¨ + ¨ to create a new row in the new sheet but I already have some data in another sheet and I want to import it here so as not to repeat
How can I do that?
---
### Author:  [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/multiple-choice-and-import-data-form-another-sheet/23410/7 "2024-01-17T16:53:15Z")