How to use Data Validation in Google Sheets
In this video, I will show you how to use Data Validation to create a drop down menu in a Google Sheet.
This is helpful in many situations, but this example uses a film production crew list.
If you would like to learn more about nerdy production things, check out my free articles and workshop at http://quentinfrismand.com/workshop
00:50 How to select columns/rows quickly
02:00 How to create banded rows
04:05 How to automatically format a phone number
06:00 How to create the drop down menu with Data Validation
Music: “Springish” by Gillicudy
CC BY NC: https://creativecommons.org/licenses/...
"Acoustic Meditation", 'River Meditation", "One fine day" by "Jason Shaw"
CC BY: https://creativecommons.org/licenses/...
From the Free Music Archive