Cascade List Google Sheets

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

  • Votes
  • Date
  • Descending date
  1. 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
    1. 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????