My scenario : Google Spreadsheet AGoogle Spreadsheet BI want a Data Validation in one cell in Spreadsheet A that it's criteria is based from a list from a range on the SpreadSheet B.I know about the imputRange function. My function range would be: =importrange(0Akd9WeCioqXWdG5CVmh4VzFrUHplSUZac3pWSGdQQ1E,Estados!A2:A11)Where 0Akd9WeCioqXWdG5CVmh4VzFrUHplSUZac3pWSGdQQ1E is the key of Spreadsheet B and Estados!A2:A11 is the Sheet and the range.But I cannot write this or any similar to this in the criteria input on the Data Validation Screen on the Spreadsheet A.
Data validation from other Google Spreadsheet
google spreadsheets