Splitting up objects in a cell

1

Hi, simple question I can’t seem to find a solution for but it’s very basic. I’m iterating through a projects table and some rows have key result inside the cell, some have more than 1 key result.

What I’m trying to do is print out all the objects in all the rows into separate rows in another key results table. Here’s the formula I have

ForEach(
  [Projects].[Key Results],
  AddRow(
    [List of Key Results],
    [List of Key Results].Name,
    if(
      CurrentValue.IsBlank() OR CurrentValue = TBD,
      "",
      if(
        CurrentValue.Count() > 1,
        foreach(
          **CurrentValue.Split(), // ???**
          Addrow(
            [List of Key Results],
            [List of Key Results].Name,
            CurrentValue)
        ),
        CurrentValue
      )
    )
  )
)

It’s working fine if there is 1 Key result but if there are more than 1, then it prints out however many there are in the cell. For my inner foreach, how can I split the Key Results “chips” so that it iterates over each of them?

2

Here you go!
The trick is to use this to get the keys (thanks @Jon_Dallas!)

Object.ParseJSON("$.*~")
2 Likes