View original (French)

Cascade List Google Sheets

Amande -  
Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   -
Hello,

I am desperately trying to configure files on Google Sheets by integrating cascading lists.
The manipulation works very well for the first row, but I can't seem to apply it to the rest of my columns.
To keep it simple, my first column suggests 5 themes, but when I move to the second row, the sub-items do not apply. It's the labels from the first row that appear.

Do you have any tips to ensure that the functionalities apply to each row, as it is a large table with many rows?

Thank you in advance for your response.

Amandine

Configuration: iPhone / Safari 14.0.3

2 answers

  1.
    JCB40 Posted messages 3058 Registration date   Status Member Last intervention   479
     
    Good evening
    An excellent tutorial
    https://www.youtube.com/watch?v=Sx6F4jZDMZU&ucbcb=1
    Best regards
    --
    Start by doing what is necessary, then do what is possible, and you will accomplish the impossible without even realizing it. Saint Francis of Assisi
    0
    1. Amande
       
      Good evening and thank you for this tutorial.
      Unfortunately, I consulted it before posting my message.
      I even followed its recommendations.

      The problem remains because it explains how to do it on a single cell but unfortunately does not explain how to apply it to the entire column????
      0