I’d like to use a rollup field with an array as an input for a formula in a different field, but it gives me an error. It seems to not be treating the rollup as a text string.
Can you post screen shots of the fields and formulas? What is the field type that you are rolling up?
I’m rolling up a text field using ARRAYUNIQUE(values).
Here’s the rollup field to be used as the input.
Here’s the formula to put index numbers in place of the commas so that the array items can be separated into individual cells more easily.
There are a few issues here.
If you are using only
ARRAYUNIQUE as your rollup aggregation formula, then the result is an array, not a text string. You can use
ARRAYJOIN in conjunction with
ARRAYUNIQUE to get a text string:
After you get the text string, you probably want to use
REPLACE instead of
SUBSTITUTE replaces all occurrences of “old text” with “new text”.
REPLACE will replace only the first instance.
I don’t know what your ultimate goal is in splitting out these fields. However, there might also be other ways to get to your end goal that don’t involve as much string manipulation.
This formula works in the rollup field, thanks @kuovonne!
Either SUBSTITUTE() or REPLACE() work fine in the other field. It would be neat to see a new formula that allows us to iterate another formula across a set of values.
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.