Forum Discussion
Riazz027
Jan 03, 2025Copper Contributor
Cascading Data Validation 3 level dropdown list with reoccurring text
Good day,
I want to make a 3 level cascading dropdown list but the 3d level is not working.
My idea is to make a budget tracker from 2 banks (Level 1) from which each bank has 3 accounts (Level 2) and each account has a different currency (Level 3). The problem arises when different accounts have the same currency.
The system does not seem to be able to read it and returns a blank dropdown.
Is there a way around it?
attached is the link to the file:
Feel free to reach out if there are any questions.
Thank you in advanced
Do you really need a drop-down in the Currency column? Each account has only one currency, so a lookup formula should be sufficient. See the attached version. I created a table with a different layout for the lookup.
Do you really need a drop-down in the Currency column? Each account has only one currency, so a lookup formula should be sufficient. See the attached version. I created a table with a different layout for the lookup.
- Riazz027Copper Contributor
It is not required to be a drop-down, no. A drop-down seemed the easiest at the time.
This will work fine. Thank you.
Appreciate it 😄
Your link does not work - "Something went wrong"
- Riazz027Copper Contributor
Nope, still the same error