Hi I am combining 2 fields (quantity and materials description) using the formula function (screenshot 1).
I am then using the lookup field to display in one cell all the materials and quantities for one job in that one cell (screenshot 2). So far s...
Thanks so much for your reply - I did try to do a rollup field instead using ARRAYCOMPACT(SUBSTITUTE(ARRAYJOIN(values), “,”, “\n”))
but it displays some blank fields so has a big gap before showing the values. It would be preferable to have less fie...
