Skip to content

Create Dynamic Dropdown Menus in Google Sheets

< 1 minute read

Sheets Green

Choices in life are always expanding and changing. Your choices in Google Sheets drop down menus should act the same way.

When a collaborator on a sheet submits an idea, wouldn’t it be amazing if that idea became an option on all the drop down menus in the Sheet, without any manual updating?

Sometimes when creating dropdown menus in Google Sheets we don’t always know what the options should be. By using the UNIQUE function, we can create dropdown menus that automatically updated based on what users are entering. That way, we can choose items based on previous entries or add a new item that will automatically update our list.

Click here to watch this video on YouTube.

Sign up for our newsletter