spreadsheet_idstring · requiredset_dropdown
Create or replace a dropdown validation rule on an A1 range. Provide either `values` for a fixed list, or both `source_sheet` and `source_range` to read options from another range in the same spreadsheet. `reject_invalid=True` blocks values outside the dropdown.
Can change or delete data
Parameters
sheetstring · requiredrangestring · requiredvaluesarray · default nullsource_sheetstring · default nullsource_rangestring · default nullreject_invalidboolean · default trueshow_dropdownboolean · default truehelp_textstring · default null