Skip to main content
added 544 characters in body
Source Link
doubleunary
  • 15.7k
  • 9
  • 23
  • 59

=IMPORTRANGE("(IMPORTRANGE(“*MASTER SPREADSHEET URL*”, “*LINKS PAGE*! B1”))","*OTHER SPREADSHEET PAGE*!A1:Z500")

That formula has several issues, including:

=IMPORTRANGE([1: "(] [2:IMPORTRANGE(“\*MASTER SPREADSHEET URL\*”,] “*LINKS PAGE*! B1”)[1: )"],"OTHER SPREADSHEET PAGE!A1:Z500")

  • [1] no quotes or parentheses required here
  • [2] if the 'LINKS PAGE' sheet is in the same spreadsheet file where this formula resides, you should not use importrange() to read the value; use a simple range reference instead

To import from the spreadsheet identified in cell B1 on the 'LINKS PAGE' sheet in your master spreadsheet, use this:

=importrange('LINKS PAGE'!B1, "OTHER SPREADSHEET PAGE!A1:Z500")

To import from the spreadsheet identified in cell B1 on the 'LINKS PAGE' sheet in your master spreadsheet, use this:

=importrange('LINKS PAGE'!B1, "OTHER SPREADSHEET PAGE!A1:Z500")

=IMPORTRANGE("(IMPORTRANGE(“*MASTER SPREADSHEET URL*”, “*LINKS PAGE*! B1”))","*OTHER SPREADSHEET PAGE*!A1:Z500")

That formula has several issues, including:

=IMPORTRANGE([1: "(] [2:IMPORTRANGE(“\*MASTER SPREADSHEET URL\*”,] “*LINKS PAGE*! B1”)[1: )"],"OTHER SPREADSHEET PAGE!A1:Z500")

  • [1] no quotes or parentheses required here
  • [2] if the 'LINKS PAGE' sheet is in the same spreadsheet file where this formula resides, you should not use importrange() to read the value; use a simple range reference instead

To import from the spreadsheet identified in cell B1 on the 'LINKS PAGE' sheet in your master spreadsheet, use this:

=importrange('LINKS PAGE'!B1, "OTHER SPREADSHEET PAGE!A1:Z500")

Source Link
doubleunary
  • 15.7k
  • 9
  • 23
  • 59

To import from the spreadsheet identified in cell B1 on the 'LINKS PAGE' sheet in your master spreadsheet, use this:

=importrange('LINKS PAGE'!B1, "OTHER SPREADSHEET PAGE!A1:Z500")