Dependent Drop-Down Lists in Google Sheets: A Step-by-Step Guide
HTML-код
- Опубликовано: 2 авг 2024
- #googlesheetstutorials #dependent_drop_down_list
-----------------------------------------------------------------------------------------------------
⇩⇩ Link to the Sheet ⇩⇩
sheetfacts.com/product/depend...
------------------------------------------------------------------------------------------------------
In this tutorial video, we will explore the powerful feature of dependent drop-down lists in Google Sheets. A dependent drop-down list is a dynamic tool that allows you to create a second list of options based on the selection made in the first list. This can be incredibly useful for organizing and filtering data, as well as streamlining your workflow. We will walk you through step-by-step how to set up and customize your own dependent drop-down lists in Google Sheets, including how to create formulas, use the data validation tool, and link multiple lists together. Whether you are a beginner or an experienced user of Google Sheets, this video will provide you with valuable insights and practical tips for using dependent drop-down lists to improve your productivity and efficiency. So sit back, grab a cup of coffee, and let's dive into the world of dependent drop-down lists!
⏰Timestamps:
00:00 Intro
00:34 Drop-down list with color in the first column
02:29 Dependent drop-down list
05:46 Return the value of marks
06:59 Pass or Fail
08:34 Wrap-up
----------------------------------------------------------------------------
⇩⇩ Link to the Sheet ⇩⇩
sheetfacts.com/product/depend...
------------------------------------------------------------------------------------------------------
❤️ Donation ❤️
"Love what you're seeing? Support our channel with a small donation - it goes a long way in keeping the good vibes and content rolling!"
---------------------------------------------------------------------------------------------------------
🌹Subscribe link
/ @techtrickswitheli2023
Related Links and useful playlists
Google sheets
• Google Sheets Tutorials
---------------------------------------------------------------
Social Media
Telegram (Quizzes and new amazing tips each day)
t.me/techtrickswithEli
X (Twitter)
/ elitechtricks - Наука
Thank you very much. I appreciate your effort. Your effort deserves appreciation.
It's my pleasure
Thank you Eli, it helped me a lot!
Glad it helped!
Thank you very much, I was looking for something like this for a long time and you taught me what I needed, extremely important content ❤❤😊😊
Glad it helped!❤
Thank you very much, I was looking for something like this for a long time and you taught me what I needed, extremely important content 😍
Glad it was helpful♥️
Great! Clear explanation ❤
🌹🌹🌹
Quite useful. Thank you!
Glad it was helpful
Great trick
Thank you very much for your help Eli
Glad it helped!
PERFECT TEACHER!!!!! THANK YOU!!!
Glad it was helpful!
Hello Eli, Great video and worked 98% for my use. But I'm having problems to make it work 100%. I did everything up until the 5:30 mark. That's exactly what I need.
BUT
I have FILTER, so when I order any collumn it breaks the drop-down (for "Student name", for exemple.) it will only return me null results, even tho I can see in the "Preparation" that everything there is working fine.
Is there a way to use FILTER and keep everything working??
Nice VERY GOOD EXPLAINATION DEAR
Glad it was helpful♥️
Nice 👍
❤❤
What about power bi
how do you get colord status updates in google sheets like Pending= yellow & shipped=green
? please help
Conditional formatting> custom formula
Thank you very much. I appreciate your effort. Your effort deserves appreciation.
So nice of you