Is it possible to link GoogleSheets without improtrange?

Question

Search Engine Optimization

Is it possible to link GoogleSheets without improtrange?
For example, so that the formula looks like this:
=if(A1:Document 1 :Sheet2 >= A1:Document 2 :Sheet2; A2 = 4) well, something like this =)
Importrange does not suit me, since there is a lot of data and I don't want to import them into the table I need.

Answer 1

Do without /. But there is no fundamental difference, just the url will be one character shorter, which is better than longer. :)

Answer 2

Wrap IMPORTRANGE in FILTER ( Data;Condition1;Condition2... ) by condition. Or try scripting the data.
Here is such a thing that can come in handy (to select the first rows of rows from the data), somehow I did it and now I constantly use it:

/**
 * Возвращает rows строк и cols столбцов из array
 *
 * @param {A:A} array Исходный массив
 * @param {10} rows Количество строк. По умолчанию возвращаются все строки
 * @param {1} cols Количество столбцов. По умолчанию возвращаются все столбцы
 * @return Возвращает rows строк и cols столбцов из array
 * @customfunction
 */
function take(array,rows,cols) {
  if (!array.map) {return array};
  var rows = rows||array.length;
  var cols = cols||array[0].length;
  
  if (array.length>rows) {array.length = rows};
  return array.map(
    function(row){
      return row.map?((row.length>cols)?row.splice(cols,row.length-cols):row):row;
    }
  );
}