Parameter List
Syntax
UPDATE(data,
[keys]
, [destination]
)data
The range or {data} cell from where data is to be inserted or updated in the destination range. The first row of data will be used as a header of the destination range. For example: A1:E4 or A2.
Pro tip: If the headers are in a column instead of a row of a range, use RANGE2JSON to create a {data} cell first.
[optional] keys
Provide an array formatted as '["key", ...]' or {["key1", ...]}. If it has only one key, you can use key1. When using ranges the first row identifies the available keys. If absent the first element from the array or range is used.
[optional] destination
The cell or range corresponding to the header of table where to insert or update the data. For example: A15:B15.