Hello all
I enter this formula for my dropdowns, for third dropdown that refer the second dropdown
=Indirect(substitute($F$4, " ", "_"))
The third dropdown works perfect but it freezes on one of the entries from second dropdown menu. I don't know how to fix it.
Any tips?
The third dropdown doesn't work for those entries which contain parentheses or dashes?
Regards,
My dependent dro
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
My dependent dro
Last edited by BittenApple on 04 Jun 2021, 23:33, edited 1 time in total.
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: My dependent dro
BittenApple wrote: ↑04 Jun 2021, 23:26Hello all
I enter this formula for my dropdowns, for third dropdown that refer the second dropdown
=Indirect(substitute($F$4, " ", "_"))
The third dropdown works perfect but it freezes on one of the entries from second dropdown menu. I don't know how to fix it.
The third Dropdown Doesn't work for those entries which contain parenthesis or dash.
Any tips?
Regards,
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: My dependent dro
Hello team,
I resolved it by entering several substitute, which substitutes "-", "(", ")", " ".
Thanks!
I resolved it by entering several substitute, which substitutes "-", "(", ")", " ".
Thanks!