Google Sheets: Hierarchal Dropdowns, date pickers, checkboxes, data validation

Data validation is imperative to have good quality data for analysis, and Google Sheets does this much better than Excel. I walk you through making date picker, checkboxes, drop-down lists where it autocompletes as you type, auto-growing drop downs and general spreadsheet etiquette to make a robust, futureproofed data input sheet.

00:00 - Introduction
00:51 - Dates & date picker
03:29 - Checkboxes
04:38 - Auto expand dropdowns
06:01 - Drop downs - new items & duplicates
06:40 - Sorting a drop-down
07:38 - Hierarchal dropdown
09:41 - Column instructions
10:48 - Email & url validation
11:20 - Pasting validation options
11:47 - Validate numbers
12:29 - Validate text that contains
12:45 - Edit & delete validation
12:55 - Data input sheets good practice

[tiawilcox]

Hi David. I would love to know more about the Google Sheets as per your conversation on Global Excel.

[nueesenki]

Hey there, great video. I have a question tho, i want the date to come up like yours so like day in numbers month in letters and years in numbers (2-Nov-2021) too but i cant seem to get that straight from the Calendar selection box. Basically if i double click on a cell to get the calendar and select a date it all in numbers ( 2-10-2021). You have any idea of how i can amend it so i get what i want?

[lafamillecarrington]

I'm interested about what happens when you set date validation relative to Today (say, between today and a weeks time), as what is true today may be untrue in the future.

[faithunlimited]

Hello, Can I get to Know "in sheets if check box is true then computer should Write Date "
How do we do this

[issacpacknett]

I put in a drop down menu then associated a v look up with it and the data from the table is not showing con$i$tent, Why?

[THALALPEDIA]

How you getting gender automatically after you select person name in the drop down? I watched this video for that only