I am looking for a way to query an imported range using named range. Something similar to this, however I cannot makeit to work
Sheet ID#A has a column J whose named range is "Signed" that may contain the following character '☑'
Sheet B uses the following formula:
=query(IMPORTRANGE("https://docs.google.com/spreadsheets/d/ID#A/", "Form Responses 1!A:ZZ"),"select * where Col"&MID(CELL("address",Signed),2,1)&" = '☑' ")
The the cell containing the formul will show NAME#? and hovering the tooltip will state "Unknown range name: 'SIGNED'."