Help

Separate String of Values by Comma

Topic Labels: Data Formulas
Solved
Jump to Solution
202 1
cancel
Showing results for 
Search instead for 
Did you mean: 
alyssarados
4 - Data Explorer
4 - Data Explorer

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! 🙂 

 

Screenshot 2024-03-06 at 11.18.06 AM.png

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

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

See Solution in Thread

1 Reply 1
Sho
11 - Venus
11 - Venus

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