DELETE

Deletes an item from an array at a given index.

Syntax 

DELETE(array, index)

Usage examples 

Example 1

Formula

DELETE(["a", "b", "c"], 1)

Output

1
[
2
"a",
3
"c"
4
]

Example 2

Accepts negative indexes.

Formula

DELETE(["a", "b", "c"], -1)

Output

1
[
2
"a",
3
"b"
4
]
Was this helpful?