Create a Dynamic DROP-DOWN List in Google Sheets - 📋✨

In this video, we delve into how to create a dynamic drop-down list in Google Sheets. This feature can enhance your data entry efficiency by allowing users to select from a pre-defined list that updates automatically.

➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions

➤You can also subscribe to the channel where you´ll find a new Sheets video every week.

Here are some of the places where you can follow and support me:

Any suggestion, question or insights, feel free to comment below

[practicalsheets]

A lot of things missing. We can add more products and see how everything works. We can also start selling combos, or products that may not have recipes, such as bottled beverages or similar items. Any other suggestion?

[habiter_en_soi]

Please do Part 2 🎉 with Prices and juices and drinks!! Thank you ❤

[oupapenya]

Thank you very much, I have been looking for something like this for a long time. I can't wait for more parts to make it a full system 🙏🏾. I run a fast foods outlet with fries, fish, sandwiches, etc.

[tallyerptutorials]

Just today I found your channel. I want Learn so many things from. So that I saved your channel link in my WhatsApp.

[habiter_en_soi]

Also could you share about the raw materials, the prices per weight and not per unit how would you right it clearly?

[habiter_en_soi]

Also, 😊 when your recipe you do a batch, for 30 portions for example, how would you link columns, to link raw materials, recipes, products and sales? Thank you

[carpeburgerbolivia]

Thank you, it was very helpful! I suggest that in the second part a menu with buttons can be added to navigate between the sheets and also to be able to make invoices. Again thank you very much!

[habiter_en_soi]

And how would you clearly enter a recipe that is used for another recipe? For exemple, a Garlic paste made for Paneer butter masala recipe, both are recipe some how, would you create a separate sheet?

[ivwandsx]

This is really helpful!! Can you add the costing, pricing, revenue, profit, and capital in the part 2??

[rahuljajoria]

Hello sir when you going to upload the second part for these video as i am having small cart and this is very useful me to track

[MasiBlue]

Do I have to buy your course to access the template? Can you provide the link to this sample worksheet?
Thank you, great video and clearly communicated!

[thierrywieder]

Hello Juan. Thanks a lot for this very professional and detailed video. I learned a lot from it. How can I add events? I make special events, and each of them has a different menu and different number of people attending. One time I may prepare 100 sandwiches (within a specific selection out of 10 different possibilities) and another time I prepare 250 sandwiches. Should I add a Sheet with events, or just a column in the Sales tab? But then how can the stock and purchase tabs be updated for each event?

[jonisarowar]

As like this video, for clothing shop, same way

[jonisarowar]

i have a clothing shop.i want to a video as like this. Sell, purchases, stock, all item in one sheet.