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


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


Is this just not possible in Google Sheets?

1 Answer 1

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


  • 1
    What if the named range is defined in another sheet on the same document? Commented Mar 5, 2019 at 17:50
  • 1
    Never mind, the named ranges are global throughout the document, so available across all sheets. Commented 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
    Commented Mar 5, 2019 at 17:55

Your Answer

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

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