Google-sheets – Named range in Data validation

google sheetsgoogle-sheets-data-validationgoogle-sheets-named-ranges

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?

Best Answer

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

0

Related Topic