Cascade List Google Sheets
Amande
-
Raymond PENTIER Posted messages 58208 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58208 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
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
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
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
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????