Create app based on Google Spreadsheet table with ImportRange

Hi, everyone! I am trying to create a Project Management App, based on a Google Spreadsheet which consolidates all the workplans of the company. This is achieved by having a Consolidated Spreadsheet with the ImportRange function.

I’ve started to build the app, but many errors are give, because of the R1C1 format.

I’ve read on the help.appsheet, that ImportRange is a function not compatible. Does that mean it is impossible to use a table with the ImportRange, to generate my appsheet?

I would appreciate your help.

Thank you!


Any suggestions or workarounds? I believe QUERY function will have the same problem, right?


I have none, I’m afraid. :frowning: