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! 🙂
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.