Skip to content

Named ranges for data validation #144

Description

@CasualAnimalEnjoyer

Describe the bug
Can't use "named ranges" as data validation for drop-down data, throwing "the list source must be a delimited list or a reference to a single row or a column" error

To Reproduce
Steps to reproduce the behavior:

  1. Create named range
  2. Go to 'Data validation' to create a drop-down menu
  3. Select named range for the drop-down
  4. See error

Expected behavior
Drop-down list will be pulled automatically

Screenshots
Image

Image Image

Device (please complete the following information):

  • OS: Linux Cashy OS
  • Version: Latest

Sheet Plus Plugin (please complete the following information):

  • Version: 2.9.0 (latest)

Additional context
You could use named ranges as normally for formulas. Though, using wrapper formula for name range as drop-down data =INDIRECT("Stars") it will pull the necessary names correctly without throwing an error

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions