Hello, At timestamp 5:16 Workflow tells you to create the second dropdown and then drag it down. Then she says we need to change the reference cells of the row the dropdowns are referring to, but we don't need to change every dropdown especially if you have 750 or more. After creating the 1st second dropdown in cell B3 just click the editing tool at the bottom of the dropdown and in the range you will see it is set as "ABSOLTE" with dollar marks. But we can remove those dollar marks and then click "Done". Now the range is set to "RELATIVE" which means if we drag the dropdown down the ranges in each dropdown will change to the "relative" row it is in or it is referring to and as you select different options in the first dropdown, the second dropdown will show only options chosen in the first dropdown. So after choosing an option in the first dropdown no matter which row, the second dropdown will only show options for that choice. I have known about this since August 26, 2022 when I created my first spreadsheet using this method instead of a script. There are plenty of you tube videos showing this method in action. James :)
For now I haven't found a shortcut for this one, but once you've learned and followed the steps on the video, you'll be able to recreate these even with 750 rows.
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
Hello,
At timestamp 5:16 Workflow tells you to create the second dropdown and then drag it down. Then she says we need to change the reference cells of the row the dropdowns are referring to, but we don't need to change every dropdown especially if you have 750 or more.
After creating the 1st second dropdown in cell B3 just click the editing tool at the bottom of the dropdown and in the range you will see it is set as "ABSOLTE" with dollar marks. But we can remove those dollar marks and then click "Done". Now the range is set to "RELATIVE" which means if we drag the dropdown down the ranges in each dropdown will change to the "relative" row it is in or it is referring to and as you select different options in the first dropdown, the second dropdown will show only options chosen in the first dropdown.
So after choosing an option in the first dropdown no matter which row, the second dropdown will only show options for that choice.
I have known about this since August 26, 2022 when I created my first spreadsheet using this method instead of a script. There are plenty of you tube videos showing this method in action.
James :)
Thanks for sharing a different methods this can also be done.
Hi, i need to do the same for 750 rows. Any shortcut method ?
For now I haven't found a shortcut for this one, but once you've learned and followed the steps on the video, you'll be able to recreate these even with 750 rows.
Hi,
Yes, I did the same I.e. I did it manually for all 750 rows.
Thanks for this video!
@Zabiulla1: You are welcome.
i tried many time but i could not make, i made but just 2 column can added.
Difficult for me to suggets a solution without more info. Try to watch all the stpes I take in the video and hopefully that will help you.