I would like to use a
ARRAY_FIRST() and a
ARRAY_LAST() function, taking an array as argument, and resulting in the first (or the last) element of this array.
For now, I have to
ARRAY_JOIN(my_array, ",") first, and the look after the string before the first “,”… which is a little tricky and need 2 formulas.
ARRAY_JOIN(my_array, ",") → my_joined_array (formula 1)
IF(FIND(',', my_joined_array) = 0, my_joined_array, LEFT(my_joined_array, FIND(',', my_joined_array) - 1)) → the final value (formula 2)
I would like to write
ARRAY_FIRST(my_array) as an unique formula…