Create Dynamic Dropdown Menus in Google Sheets
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.
To read the full article, visit this link: https://www.bettercloud.com/monitor/t...