We've got them! Multiple selection data validation selections are now native in Google Sheets!
Get Good at Spreadsheets Now: [ Ссылка ]
This comes directly on the heels of tables finally rolling out over the last few months.
Good times!
I made another popular video on this topic a couple years ago when we had to use apps script to make it happen: [ Ссылка ]
This video goes over the couple things that most people asked me about in that video.
=============================
We receive commission on purchases made through some links on this page
🗞️ Starting a Newsletter? Check out Beehiiv with a free trial and 20% off your first 3 months: [ Ссылка ]
🖥️ Office items I can't live without:
[ Ссылка ] (amazon)
🎓Course Suggestions:
► Advanced Data Analytics Certificate by Google: [ Ссылка ] (coursera)
► Cybersecurity by Google: [ Ссылка ] (coursera)
► HubSpot free CRM software for sales, marketing, customer service, operations teams. [ Ссылка ]
=============================
📲 Find me
on LinkedIn: [ Ссылка ]
on Twitter: [ Ссылка ]
on website: [ Ссылка ]
=============================
⌚Chapter Time Markers:
00:00:00 - setup
00:00:14 - old way
00:00:51 - 2024 updated way
00:01:08 - table
00:01:20 - data validation setup
00:02:26 - demo counting values
00:03:17 - split
00:03:51 - counta for unique values
00:04:51 - arrayformula
00:05:49 - countif plus arrayformula
00:07:01 - adding table rows
00:07:25 - multiple criteria dynamic checkbox preview
Ещё видео!