Skip to main content

Is there a way to format the items in the rollup field to look like this (including brackets on either side):



[“Choice1”,“Choice2”,“Choice3”,“Choice4”,“Choice5”]



I have this formula but it does not work in a rollup field:


' "' & 
SUBSTITUTE(
Choices,
', ',
'","'
) &
'"]'

Then I found this sample code:


IF(
ARRAYJOIN(values),
"- " & ARRAYJOIN(values, "\n- ")
)

But I can’t figure out how to combine them without an error.


IF(
ARRAYUNIQUE(values),
'Q"' & ARRAYUNIQUE(values, ', ',
'",") &
'"]'
)

All these “,”"’’ are making me go cross eyed. Please help me! 🤣

Still trying different configurations, but I still can’t get it to work. What am I doing wrong? Is this even possible?


Still trying different configurations, but I still can’t get it to work. What am I doing wrong? Is this even possible?


Your last formula is close. Try:


IF(
values,
' "' & ARRAYJOIN(ARRAYUNIQUE(values), '", "') & '"]'
)

Thank you! I don’t know why I didn’t use both arrayjoin and arrayunique.


Reply