Dynamic Select on multiple rows in a Google Sheet

If you’ve ever found yourself looking how to create a dynamic select on multiple rows in a Google Sheet and you do not know even where to start, you’ve come to the right place.

If you get to the end of this post, you will find the link to the spreadsheet that I use as an example of doing just that.

In the example we will see how to handle a select with a series of certain categories, and another select of subcategories that will be filled dynamically depending on the value of the first.

Also, we will see how we can do that in multiple rows, in such a way that we can have a table as big as we need, where in each row, we can select the category and, for that row, the subcategory cell is filled dynamically .

It will be easier for you to understand if, instead of reading it, you take a look to the video. And even more so if in addition to watching it, you have a spreadsheet next to you so that you can replicate the steps. If you know me, you already know that I am an advocate that learning is learned by doing.

So without much more, I leave you with the video where I explain in detail how to have a dynamic select in multiple rows in a Google Sheet. The bad new is that so far it is just in Spanish. Hopefully I could have it in English also, but anyway, you could leverage the subtitles in Youtube.


I did not forget what I promised you above, so here you can find the Google spreadsheet which you can use for whatever you need. Just make a copy and… that is it!