Dependent dropdown with multiple selection in Google Sheets

Поділитися
Вставка
  • Опубліковано 4 січ 2025

КОМЕНТАРІ • 12

  • @rosalbakai7171
    @rosalbakai7171 4 місяці тому +1

    How do you add this code or formula to more sheets

    • @practicalsheets
      @practicalsheets  4 місяці тому

      I have answered in the multiple dropdown video for Sheets
      ua-cam.com/video/0FLPpHyiMkA/v-deo.html&lc=UgyRYKmvCxhh5L_XA1V4AaABAg
      Kind Regards

  • @maryl3212
    @maryl3212 8 місяців тому +1

    Great video! Can you make multiple selections in the first column and filter the dependent dropdown for all of the selected values?

    • @practicalsheets
      @practicalsheets  8 місяців тому +1

      Hmmmm
      Very interesting
      How would you do if you select 4 options? you bring the suboptions for all 4?
      Kind Regards

    • @maryl3212
      @maryl3212 8 місяців тому +1

      @@practicalsheets yes, filter the dependent dropdown for all values chosen.

    • @practicalsheets
      @practicalsheets  8 місяців тому

      @@maryl3212 I think it may be done. A bit complicated but I think it's doable
      Regards!

    • @DaniaAnwar-l2l
      @DaniaAnwar-l2l 5 місяців тому +2

      @@practicalsheets Is there any video for multiple selections in the first column and filter the dependent dropdown for all of the selected values?

    • @practicalsheets
      @practicalsheets  5 місяців тому +1

      @@DaniaAnwar-l2l Hello
      Wow!
      Expert level alert!
      I suppose it could be done, but I don't have a video
      Kind Regards

  • @eduardapacheco4394
    @eduardapacheco4394 4 місяці тому +1

    Hi!!
    Can I do with no code?
    I'm trying doing with this code but is not working

    • @practicalsheets
      @practicalsheets  4 місяці тому

      Very soon Sheets will implement multiple dropdowns functionality directly (in a couple of weeks), I would wait so you may do it without code
      Kind Regards

  • @PjAyzB
    @PjAyzB 8 місяців тому +1

    Hi, I cannot proceed with the multiple dropdown from the formula that you gave from this video ua-cam.com/video/0FLPpHyiMkA/v-deo.html. I was trying to do it from the start but it gave me the same result. and to add I want to have my multiple dropdown from column 2 to 3-50 rows and to add the following columns. (2-9)

    • @practicalsheets
      @practicalsheets  8 місяців тому

      You are trying to do the project from this video, or the one you link?
      Regards!