If you change the content of the range you select, the changes are made in the list automatically. Then, under "Display Style," select either:
This will open the Data Validation dialog box. On the Data tab, in the Data Tools group, click Data Validation.
To change the display style: Click Advanced options. Select the cell (s) containing the drop-down list. To change the options listed, edit the items under "Criteria.". Select the cell or cells you want to change, then select an option:. 
To remove the value from the list, change the source range or any other item’s color. Important: If you delete a value with an assigned color from the criteria source range when the dropdown is populated from a range, the value and color will still appear under criteria, but as uneditable.
Click Advanced options, and under "If the data is invalid:," select "Show a warning.". If you want people to be able to enter items not from the list: OPTIONAL: If you enter data in a cell that doesn’t match an item on the list, it is rejected. Click Add another item to add additional dropdown values. Dropdown from a range: Choose the cells to include in the list. Select an option: On the Data validation rules panel. On the Data validation rules panel, under "Criteria," select an option: Select the cell or cells where you want to create a dropdown list. Enter In the Menu, under the components section, click “ Dropdowns.". Select the cell or cells where you want to create a dropdown list. Range.Create drop-down lists in a cell with Google Sheets. Spreadsheet.getRange(a1Notation) (Apps Script reference). VALIDATED_RANGE must be a fully an A1 range with the sheet (for example Values!A1:A).Īlso, you may need to modify it for your needs. OPTIONS_SHEET_NAME is the name of the sheet with the options. Stop the function if the edit is not on the options page or the edited value was empty or it has been removed: if (!oldValue || !value || range.getSheet().getName() != OPTIONS_SHEET_NAME)Īnd finally do the replace: const target = source.getRange(VALIDATED_RANGE) To replace a value you can use TextFinder: function changeOptions(target, search, replaceWith) = e
0 kommentar(er)
