GOOGLE.SHEETS.COLUMN.INSERT
Premium
Experimental
Insert or append columns to a sheet.
Syntax
=GOOGLE.SHEETS.COLUMN.INSERT(Spreadsheet-Id, Sheet-Id or Sheet-Name, Cell Range, [Column])
Arguments
| Name | Type | Description |
|---|---|---|
| Spreadsheet-Id | Text | The id of the spreadsheet to add columns to. |
| Sheet-Id or Sheet-Name | Number,Text | ID or name of the sheet to add columns to. |
| Cell Range | Range | A cell range which contains the values of the columns to insert. |
| Column (optional) | Text | Column to insert at. If not specified new columns will be appended. |
Return
| Type | Description |
|---|---|
| Boolean | TRUE if insert was successful. |
Examples
| Formula | Result | Comment |
|---|---|---|
| TRUE | Inserts values from range D2:F5 to columns starting at G in sheet S2 of spreadsheet with ID given in B2. |