Help

Unique array combining arrays from 2 rollup fields

11251 21
cancel
Showing results for 
Search instead for 
Did you mean: 
Kat_Levine
5 - Automation Enthusiast
5 - Automation Enthusiast

I have 2 rollup fields in a table that are formatted to show ARRAYUNIQUE(values). I am trying to create a formula column that combines these values in an array, and only displays unique values. I was trying to use: ARRAYUNIQUE({Rollup1},{Rollup2}), but am only getting the values from Rollup1 to show up. Help?

21 Replies 21

Hi Colby, roger that.  I've updated the base's automation and extension to handle the case where Array#1 or Array#2 is empty I believe.  Lemme know if you hit any issues

That worked, thank you!