CODEWITHSUNDEEP
jsongoogle-apps-scriptgoogle-sheetsgoogle-sheets-formulacustom-function
Ron hamilton
Ron hamilton

Reputation: 49

Using cell adjacent to ImportJSON throws error: Array result was not expanded because it would overwrite data

I am importing an individual parameter using the importJSON function in Google Sheets.

See post: Importjson exclude parameters spreadsheet

When I use

=importJSON("url", "/name","noHeaders")

this works perfectly to import the exact cell I need but I cannot use the cell to the right of the import.

E.G:

Cell A1 =importJSON("url", "/name","noHeaders"), If I type any text into Cell B1 I receive

"Error: Array result was not expanded because it would overwrite data in B1"

and Cell A1 displays #REF!. Then once I delete text in B1 the importJSON value reappears back into A1 and the error clears. Is there a way to fix this so I can have data next to the importJSON cell?

Any help would be much appreciated.

Upvotes: 0

Views: 259

Answers (1)

TheMaster
TheMaster

Reputation: 50880

If you only want 1 value from the import, INDEX into it:

=INDEX(IMPORTJSON("url", "/name","noHeaders"), 1, 1)

You may also use ARRAYCONSTRAIN() to constrain the array.

Syntax:

=INDEX(array, [row], [column])

Upvotes: 2

Related Questions