- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 06, 2024 09:25 AM - edited ‎Mar 06, 2024 09:26 AM
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! 🙂
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 06, 2024 03:50 PM
If it is a Lookup field, the Arrayslice function could be used.
The following formula extracts the first one
ARRAYSLICE({Lookup field)},1,1)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 06, 2024 03:50 PM
If it is a Lookup field, the Arrayslice function could be used.
The following formula extracts the first one
ARRAYSLICE({Lookup field)},1,1)
