Create dropdowns from lists

Marketing Analytics in Google Sheets

Luke Pajer

Digital Marketing Specialist

Find the issue

Marketing Analytics in Google Sheets

Find the issue

  • R Users campaign will not aggregate correctly
Marketing Analytics in Google Sheets

Data validations: dropdowns

Two types of dropdown validations

  1. List from a range
    • Options generated from a selected range
    • Better for larger and/or often modified lists
  2. List of items
    • List entered manually in settings
    • Better for a short list
Marketing Analytics in Google Sheets

Dropdown: list from a range settings

Marketing Analytics in Google Sheets

Dropdown: list of items settings

Marketing Analytics in Google Sheets

Dropdown: usage

Marketing Analytics in Google Sheets

Dropdown: bad data entry

Marketing Analytics in Google Sheets

Let's get to work!

Marketing Analytics in Google Sheets

Preparing Video For Download...