Separate String of Values by Comma

[alyssarados]

I am trying to separate the values in the "ADKAR numerical value" column so that the first number (2) is inputted into the "Awareness value" column. Then so on where I input the next number after the comma into another column, etc.

Any help is greatly appreciated! 🙂 

[Sho · Accepted solution]

If it is a Lookup field, the Arrayslice function could be used.

The following formula extracts the first one

ARRAYSLICE({Lookup field)},1,1)

Using Array Functions In Airtable | Airtable Support