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)...
- Jan 17, 2025
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.
HansVogelaar
Jan 17, 2025MVP
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.
- Riazz027Jan 19, 2025Copper 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 😄