Master DROPDOWNS in Google Sheets: Custom Ordering Made Easy! 📊

Practical Sheets • April 3, 2024
Video Thumbnail
Practical Sheets Logo

Practical Sheets

View Channel

About

GOOGLE SHEETS - GOOGLE FORMS - GOOGLE APPS SCRIPTS - ONLY PRACTICAL PROJECTS AND TIPS - NEW VIDEOS ON WEDNESDAYS - [email protected]

Video Description

In this video, we dive deep into the world of dropdowns in Google Sheets, showing you how to customize their order in various ways. Learn to sort dropdowns alphabetically, by population, or any other variable. Plus, discover how to dynamically update dropdowns based on user input and frequency of selection. Perfect for those looking to enhance their data organization skills in Sheets! ➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions https://practicalsheets.com/patreon You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more ➤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: ➤Patreon: https://practicalsheets.com/patreon ➤Webpage: https://practicalsheets.com ➤Newsletter: https://practicalsheets.com/newsletter ➤Telegram: https://practicalsheets.com/telegram ➤Facebook: https://practicalsheets.com/facebook ➤Twitter: https://practicalsheets.com/twitter Any suggestion, question or insights, feel free to comment below

You May Also Like

Boost Your Spreadsheet Skills

AI-recommended products based on this video

Loading...
(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

(3,057)
$15.99
Prime
200+ bought in past month
Loading...
INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

(520)
$41.42
PrimeFREE delivery Sat, Jun 14
500+ bought in past month
Loading...
INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

(79,368)
$25.99
FREE delivery Wed, Aug 20 on your first order
5K+ bought in past month
Loading...
acer Chromebook 315 Laptop | Intel Pentium Silver N6000 | 15.6" Full HD IPS Touch | Intel UHD Graphics | 8GB LPDDR4X | 64GB eMMC | Wi-Fi 6 | DTS Audio | Protective Sleeve | Chrome OS | CB315-4HT-P8PQ

acer Chromebook 315 Laptop | Intel Pentium Silver N6000 | 15.6" Full HD IPS Touch | Intel UHD Graphics | 8GB LPDDR4X | 64GB eMMC | Wi-Fi 6 | DTS Audio | Protective Sleeve | Chrome OS | CB315-4HT-P8PQ

(35)
$449.99
FREE delivery Sun, Jun 15
Loading...
Laptop Sleeve Case 11–14 Inch MacBook Air MacBook Pro Surface Laptop Dell XPS 13 HP Envy Pavilion Lenovo Yoga Slim IdeaPad Acer Swift Chromebook Samsung Galaxy Book Shockproof Leather Bag Colour Blue

Laptop Sleeve Case 11–14 Inch MacBook Air MacBook Pro Surface Laptop Dell XPS 13 HP Envy Pavilion Lenovo Yoga Slim IdeaPad Acer Swift Chromebook Samsung Galaxy Book Shockproof Leather Bag Colour Blue

(98)
$81.45
Loading...
SanDisk Ultra Dual Drive Luxe USB 3.1 Type-C 32GB Flash Drive for Acer Convertible 2-in-1 Laptops Aspire 1, Chromebook Spin 713 (SDDDC4-032G-G46) Gen1 Bundle with (1) Everything But Stromboli Lanyard

SanDisk Ultra Dual Drive Luxe USB 3.1 Type-C 32GB Flash Drive for Acer Convertible 2-in-1 Laptops Aspire 1, Chromebook Spin 713 (SDDDC4-032G-G46) Gen1 Bundle with (1) Everything But Stromboli Lanyard

(9)
$79.11
Loading...
12V/24V 100W Car Laptop Charger USB C for Lenovo Thinkpad MacBook HP Dell Acer Asus,Google,MSI, LG, Samsung,Huawei,Surface pro 9 8, Razer, Chromebook, ROG Ally, Steam Deck and All Type-C Devices

12V/24V 100W Car Laptop Charger USB C for Lenovo Thinkpad MacBook HP Dell Acer Asus,Google,MSI, LG, Samsung,Huawei,Surface pro 9 8, Razer, Chromebook, ROG Ally, Steam Deck and All Type-C Devices

(6)
$29.99
FREE delivery Tue, Jun 17 on your first order
50+ bought in past month
Loading...
Logitech M185 Wireless Mouse, 2.4GHz with USB Mini Receiver, 12-Month Battery Life, 1000 DPI Optical Tracking, Ambidextrous, Compatible with PC, Mac, Laptop - Black

Logitech M185 Wireless Mouse, 2.4GHz with USB Mini Receiver, 12-Month Battery Life, 1000 DPI Optical Tracking, Ambidextrous, Compatible with PC, Mac, Laptop - Black

(43,809)
$14.99$11.99
FREE delivery Mon, Sep 22 on your first order
1K+ bought in past month
Loading...
Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black
Best Seller

Logitech G203 Wired Gaming Mouse, 8,000 DPI, Rainbow Optical Effect LIGHTSYNC RGB, 6 Programmable Buttons, On-Board Memory, Screen Mapping, PC/Mac Computer and Laptop Compatible - Black

(17,871)
$27.98$22.38
FREE delivery Tue, Oct 14 on your first order
500+ bought in past month
Loading...
Logitech G305 LIGHTSPEED Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black

Logitech G305 LIGHTSPEED Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black

(21,223)
$44.98
FREE delivery Tue, Oct 14
1K+ bought in past month
Loading...
Logitech G502 HERO High Performance Wired Gaming Mouse, HERO 25K Sensor, 25,600 DPI, RGB, Adjustable Weights, 11 Programmable Buttons, On-Board Memory, PC / Mac, Black
Best Seller

Logitech G502 HERO High Performance Wired Gaming Mouse, HERO 25K Sensor, 25,600 DPI, RGB, Adjustable Weights, 11 Programmable Buttons, On-Board Memory, PC / Mac, Black

(54,445)
$49.98$44.98
FREE delivery Tue, Oct 14
1K+ bought in past month
Loading...
Dell 24 Monitor - SE2425HM - 23.8-inch Full HD (1920x1080) 16:9 100Hz Display, IPS Panel, 16.70 Million Colors, Anti-Glare, 1 HDMI / 1 VGA Port, TÜV Rheinland 3-Star*, Comfortview Plus - Black

Dell 24 Monitor - SE2425HM - 23.8-inch Full HD (1920x1080) 16:9 100Hz Display, IPS Panel, 16.70 Million Colors, Anti-Glare, 1 HDMI / 1 VGA Port, TÜV Rheinland 3-Star*, Comfortview Plus - Black

(169)
$119.99$103.99
FREE delivery Tue, Oct 7
300+ bought in past month
Loading...
Dell S2425HS Monitor - 23.8 Inch, FHD (1920x1080) Display, 100Hz Refresh Rate 1500:1 Contrast Ratio, TÜV Rheinland Eye Comfort 4 Star, Integrated 2x5W Speaker, Height/Tilt/Swivel/Pivot - Ash White

Dell S2425HS Monitor - 23.8 Inch, FHD (1920x1080) Display, 100Hz Refresh Rate 1500:1 Contrast Ratio, TÜV Rheinland Eye Comfort 4 Star, Integrated 2x5W Speaker, Height/Tilt/Swivel/Pivot - Ash White

(15)
$139.99
FREE delivery Tue, Oct 7
300+ bought in past month
Loading...
USB C Docking Station Dual Monitor for Dell Hp,15-in-1 Laptop Docking Station 3 Monitors USB C Hub with Dual 4K HDMI,8K DP,Button,PD Charging,Ethernet,6 USB A&C,SD/TF, Audio USB-C Multiport Adapter

USB C Docking Station Dual Monitor for Dell Hp,15-in-1 Laptop Docking Station 3 Monitors USB C Hub with Dual 4K HDMI,8K DP,Button,PD Charging,Ethernet,6 USB A&C,SD/TF, Audio USB-C Multiport Adapter

(1,359)
$67.98
FREE delivery Sun, Aug 24
100+ bought in past month
Loading...
Dell 24 Monitor - P2425H EPEAT

Dell 24 Monitor - P2425H EPEAT

(57)
$239.99$189.05
FREE delivery Tue, Oct 7
50+ bought in past month
Loading...
Dell Multi-Device Wireless Keyboard and Mouse Combo - KM7120W

Dell Multi-Device Wireless Keyboard and Mouse Combo - KM7120W

(1,812)
$128.86$109.99
FREE delivery Aug 22 - 25Only 8 left in stock.
Loading...
tomtoc 360 Protective Laptop Sleeve for 15.6 Inch Acer Aspire 1/3/5 15 Slim Laptop, 15.6-16 Inch ASUS Strix G16/G15, HP Pavilion 15, Lenovo Ideapad 3 Laptop, 15.6 Inch Dell Samsung Notebook Ultrabook

tomtoc 360 Protective Laptop Sleeve for 15.6 Inch Acer Aspire 1/3/5 15 Slim Laptop, 15.6-16 Inch ASUS Strix G16/G15, HP Pavilion 15, Lenovo Ideapad 3 Laptop, 15.6 Inch Dell Samsung Notebook Ultrabook

(3,132)
$37.59
FREE delivery Sat, Jun 21
Loading...
SAMSUNG 870 EVO SATA SSD 500GB 2.5” Internal Solid State Drive, Upgrade PC or Laptop Memory and Storage for IT Pros, Creators, Everyday Users, MZ-77E500B/AM [Canada Version]

SAMSUNG 870 EVO SATA SSD 500GB 2.5” Internal Solid State Drive, Upgrade PC or Laptop Memory and Storage for IT Pros, Creators, Everyday Users, MZ-77E500B/AM [Canada Version]

(41,678)
$74.97
FREE delivery Wed, Jun 18
400+ bought in past month
Loading...
SAMSUNG 870 EVO SATA III SSD 4TB 2.5” Internal Solid State Drive, Upgrade PC or Laptop Memory and Storage for IT Pros, Creators, Everyday Users, MZ-77E4T0B/AM [Canada Version]

SAMSUNG 870 EVO SATA III SSD 4TB 2.5” Internal Solid State Drive, Upgrade PC or Laptop Memory and Storage for IT Pros, Creators, Everyday Users, MZ-77E4T0B/AM [Canada Version]

(41,656)
$399.97
FREE delivery Tue, Jun 17
100+ bought in past month
Loading...
Samsung 990 EVO Plus - 4TB PCIe Gen4. X4, Gen5. X2 NVMe 2.0 - M.2 Internal SSD, Speed Up to 7,250 MBs, Upgrade Storage for PC-Laptops, HMB Technology and Intelligent Turbowrite (MZ-V9S4T0B/AM)

Samsung 990 EVO Plus - 4TB PCIe Gen4. X4, Gen5. X2 NVMe 2.0 - M.2 Internal SSD, Speed Up to 7,250 MBs, Upgrade Storage for PC-Laptops, HMB Technology and Intelligent Turbowrite (MZ-V9S4T0B/AM)

(1,811)
$359.99$341.99
FREE delivery Tue, Jun 17
100+ bought in past month
Loading...
SAMSUNG 990 PRO SSD 4TB PCIe Gen4 NVMe M.2 Internal Solid State Hard Drive, Up to 7,450MB/s, Heat Control, Direct Storage and Memory Expansion, MZ-V9P4T0B/AM [Canada Version]

SAMSUNG 990 PRO SSD 4TB PCIe Gen4 NVMe M.2 Internal Solid State Hard Drive, Up to 7,450MB/s, Heat Control, Direct Storage and Memory Expansion, MZ-V9P4T0B/AM [Canada Version]

(12,872)
$499.97$407.80
FREE delivery Tue, Jun 17
300+ bought in past month
Loading...
100W 90W USB-C Charger Type-C Adapter for Lenovo Thinkpad Carbon x1 5th 6th Gen, IdeaPad 13" 720 Y400 Y500 P580 P500, Yoga 370 X280 X390 910 920 Power Cord GX20M33579 4X20M26268

100W 90W USB-C Charger Type-C Adapter for Lenovo Thinkpad Carbon x1 5th 6th Gen, IdeaPad 13" 720 Y400 Y500 P580 P500, Yoga 370 X280 X390 910 920 Power Cord GX20M33579 4X20M26268

(43)
$24.99
FREE delivery Sun, Jun 22 on your first order
Loading...
65W USB C Laptop Charger for Lenovo Thinkpad X1 Carbon T470 T480 T490 T590 E580 E590 E595 Yoga IdeaPad Chromebook Power Supply Adapter Cord 20V 3.25A

65W USB C Laptop Charger for Lenovo Thinkpad X1 Carbon T470 T480 T490 T590 E580 E590 E595 Yoga IdeaPad Chromebook Power Supply Adapter Cord 20V 3.25A

(5)
$19.99
FREE delivery Tue, Jun 17 on your first order
50+ bought in past month
Loading...
45W 65W Laptop Charger for Lenovo Thinkpad X1 Carbon T460 T470 T470S T440 T540 X260 X240 X270 G40 G50 G50-80 E560 E450, Yoga 2 11/2 Pro/ 11s 13 Flex 2 2-15 Ideapad 300 500 700 Power Supply Cord

45W 65W Laptop Charger for Lenovo Thinkpad X1 Carbon T460 T470 T470S T440 T540 X260 X240 X270 G40 G50 G50-80 E560 E450, Yoga 2 11/2 Pro/ 11s 13 Flex 2 2-15 Ideapad 300 500 700 Power Supply Cord

(46)
$19.99
FREE delivery Sun, Jun 22 on your first order
Loading...
65W USB C for Lenovo Laptop Charger for Lenovo Thinkpad/Chromebook/Ideapad/Yoga Series-USB C Laptop Charger for Lenovo T14 Thinkpad T480 T490 Yoga 7i 9i Thinkpad X1 Carbon

65W USB C for Lenovo Laptop Charger for Lenovo Thinkpad/Chromebook/Ideapad/Yoga Series-USB C Laptop Charger for Lenovo T14 Thinkpad T480 T490 Yoga 7i 9i Thinkpad X1 Carbon

(11)
$24.09
FREE delivery Sun, Jun 22 on your first order
500+ bought in past month
Loading...
INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

(520)
$41.42
PrimeFREE delivery Sat, Jun 14
500+ bought in past month
Loading...
INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

(79,368)
$25.99
FREE delivery Wed, Aug 20 on your first order
5K+ bought in past month