Automation Help

[msiraj]

@hendrik

Btw, I am now doing what I am usually doing in google sheets

=ARRAYFORMULA(IFERROR(INDEX(invoiceitems!$C$2:$C$15, SMALL(IF($F$2=invoiceitems!$B$2:$B$15, ROW(invoiceitems!$B$2:$B$15)-ROW(invoiceitems!$B$2)+1), ROW(1:1))),"" ))

But this doesn’t seem to work. Anything wrong with my formula?

This a product issue around evaluating ARRAYFORMULA, we will be addressing it one of the forthcoming product updates. Tracking as #004829.