Skip to main content
Web Applications

Return to Question

Post Closed as "Needs details or clarity" by Rubén - Volunteer Moderator -♦, serenesat, jonsca
added 4 characters in body; edited tags; edited title
Source Link
user0
user0
  • 27.1k
  • 10
  • 53
  • 78

Equivalent of IMPORTRANGE() with script in Google Sheets

Since the Importrange()Importrange() is not working as expected, do you know how I could express ee.g the following function with a script?

={IMPORTRANGE("SheetKey","SheetName1!A:J") ; 
  IMPORTRANGE("SheetKey","SheetName2!A2:J") ; 
  IMPORTRANGE("SheetKey","SheetName3!A2:J")}

Thank you

Equivalent of IMPORTRANGE() with script in Google Sheets

Since the Importrange() is not working as expected, do you know how I could express e.g the following function with a script?

={IMPORTRANGE("SheetKey","SheetName1!A:J") ; IMPORTRANGE("SheetKey","SheetName2!A2:J") ; IMPORTRANGE("SheetKey","SheetName3!A2:J")}

Thank you

Equivalent of IMPORTRANGE with script in Google Sheets

Since the Importrange() is not working as expected, do you know how I could express e.g the following function with a script?

={IMPORTRANGE("SheetKey","SheetName1!A:J") ; 
  IMPORTRANGE("SheetKey","SheetName2!A2:J") ; 
  IMPORTRANGE("SheetKey","SheetName3!A2:J")}
Source Link
aptbs85
aptbs85
  • 13
  • 2

Equivalent of IMPORTRANGE() with script in Google Sheets

Since the Importrange() is not working as expected, do you know how I could express e.g the following function with a script?

={IMPORTRANGE("SheetKey","SheetName1!A:J") ; IMPORTRANGE("SheetKey","SheetName2!A2:J") ; IMPORTRANGE("SheetKey","SheetName3!A2:J")}

Thank you