File Spreadsheet settings.
Google form dropdown from sheet. This makes it easy to make errors in the order form collected from your customers. Let us create a multi-row dependent dropdown list in Google Sheets containing all the dishes from the menu for customers to select from. This enables the customers to dependently select the dishes according to the events and the number of courses they want in an event. 1 First open Google Sheet with Data as shown below. 2 click on File Spreadsheet settings.