I'm trying to update this formula so it will work inside of an 'arrayformula'.
This works on its own and when I fill it down.
=if(E2>0,CONCATENATE(B2, " | ",C2," | ",D2), "")
This does not work when rows are added to the spreadsheet.
=arrayformula(if(E2:E>0,CONCATENATE(B2, " | ",C2," | ",D2), ""))
It only repeats the values in row 2 over and over again.
How should I write 'b2' and 'c2' and 'd2' so they adjust to row3, 4, 5, and so on as the number of rows expand?