4

I am having trouble getting a named range to work in the data-validation criteria selection.

Given that my named range is "ContactRecord" and the rangeid=1234567890, in the data-validation criteria selection it should be able to support named ranges:

For example:

instead of

'SheetX'!B60:B70

I should be able to use the named range as the reference like:

'SheetX'!rangename=ContactRecord
'SheetX'!rangeid=1234567890

Is this just not possible in Google Sheets?

Improve this question

1 Answer 1

Reset to default
3
  • when referencing a Named range in Data validation, you don't need to include sheet name:

0

Improve this answer
3
  • 1
    What if the named range is defined in another sheet on the same document?
    – Ivan Dossev
    Mar 5, 2019 at 17:50
  • 1
    Never mind, the named ranges are global throughout the document, so available across all sheets.
    – Ivan Dossev
    Mar 5, 2019 at 17:54
  • even then it applies the same. see the picture - I created named range in Sheet1 and on Sheet2 I used same named range without sheet reference. yes, they are global...
    – user0
    Mar 5, 2019 at 17:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.