Create Dynamic Dropdown Menus in Google Sheets
August 26, 2015 / / Comments Off on Create Dynamic Dropdown Menus in Google Sheets
< 1 minute read
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.
