Spreadsheet Formula

[NCD]

I'm trying to put this in my AppSheet "Spreadsheet formula".

=CONCATENATE(index(split(QUERY(IMPORTDATA("http://zipcloud.ibsnet.co.jp/api/search?zipcode="&E36),"select * where Col1 like 'ad%'"),""""),,2))

But I don't want it to look at E36 every time, instead I want it to be the left cell every time.

How do I do this?

[TeeSee1 · Accepted solution]

INDIRECT(ADDRESS(ROW(), COLUMN() - 1))

gives you the content of the cell left to the cell containing the formula.

Try replacing E36 with this..

[NCD]

Thank you it worked perfectly!

[WillowMobileSys]

The Spreadsheet formula must adhere to certain formations.  I believe what you have written is not supported.  Review the first article below for more details.

To understand more about the Spreadsheet Formula property here are some articles:

https://help.appsheet.com/en/articles/2926968-issues-with-google-sheets-formulas

https://help.appsheet.com/en/articles/961393-spreadsheet-formulas

https://help.appsheet.com/en/articles/3326638-mismatched-spreadsheet-formulas

[TeeSee1]

Thanks @WillowMobileSys 

I was thinking purely in terms of Spreadsheet functionality without considering AppSheet compatibility.