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...
Watch video Create Dynamic Dropdown Menus in Google Sheets online, duration hours minute second in high quality that is uploaded to the channel BetterCloud 26 May 2016. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 95,741 times and liked it 363 visitors.