Solved: Going through a List

Nicolas_St-Laur · 03-03-2021 01:21 PM

Is it possible in app sheets to go through a column of lists and add something to each item?

EX:

Test ID : TS_Security
List: {Item 1, Item 2, Item 3}

I want the list to be: {TS_Security:Item 1, TS_Security:Item 2, TS_Security:Item 3}

Marc_Dillon

Something like this?

SPLIT(
  "TS_SECURITY:"
  &
  SUBSTITUTE(
    CONCATENATE( old-list ) ,
    "," ,
    ", TS_SECURITY:"
    ),
  ","
)

Marc_Dillon

Something like this?

SPLIT(
  "TS_SECURITY:"
  &
  SUBSTITUTE(
    CONCATENATE( old-list ) ,
    "," ,
    ", TS_SECURITY:"
    ),
  ","
)

Nicolas_St-Laur

That’s exactly what I needed, thank you so much for your help