VALUEAT
Formula Explanation
Get the nth value in an array-like string.
Formula Syntax
Enter in the result column: valueat(array-like string / column number, position n)
- Array-like string: Must be enclosed in "[]", for example: [1,2,3]; If the string is not array-like, the formula returns an empty value.
- Position n: Starting from 1, if the position exceeds the length of the array, it returns an empty value.
- Parameters can also be replaced with data column codes, which are the codes at the top of each column in the table, e.g., AA1.
Usage Example
Write the 3rd value of the array in column FA2 to column FA3.
FA3 = valueat(FA2, 3)