I have a use case like below…
- I have 10 fruits
- Each fruit has 15 types.
- Now 10 fruits are in column A in google sheet
- Each fruit types are listed subsequently in B,C,D,…n columns in the same google sheet
- Now I have populated 10 fruits in a choice
- When a fruit is selected, I have to populate all its fruit types (15) in another choice
Can any one throw some light on how to achieve this.
Thanks & Regards,
Manohar AKA Anum