Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
I have several raw data files which I have linked with importrange to another files.
For some reason my files where getting broken since I keep getting importrange internal error. Also, they take too long to load any data.
Is there any workaround that I can use instead of importrange or apps script?
Try this iferror() pattern:
=iferror( importrange("...", lower("Sheet1!A2:D")), importrange("...", upper("Sheet1!A2:D")) )
