Google Sheets: Color-coded Dropdowns for easy, meaningful data entry (New Feature!)

Google Sheets has a new feature to add dropdown menus and you can color code them, too. Dropdown are really easy to set up, and they allow people adding data to your spreadsheet to easily enter data by selecting from a dropdown menu. ↓ see slides/demo sheet below for more information ↓ #googlesheets #spreadsheet #spreadsheettutorial #googlesheetstutorial #googlesheetstips #googlefeatures You can also use dropdown in conjunction with another new feature, Timelines (Gantt charts), to color code the timeline cards based on your dropdown selections! Slides: doittraining.page.link/dropdownslides Copy Demo sheet to follow along: doittraining.page.link/dropdownsdemo 0:00 Intro 0:09 Insert the Dropdown 0:24 Customize dropdown options 0:43 Dropdown (from a range) 1:36 Advanced options 2:37 Edit existing dropdowns 3:22 Use dropdowns in conjunction with Timelines New Google Feature, new Google Sheets feature, spreadsheet dropdown, easy data entry

• #education
• #tutorial
• #educational