Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 08, 2022 11:58 AM
Hey Airtable Community,
I am trying to create a roll up formula combination that is taking a list of values some of those are blank and only outputs a bulleted list of the filled in values.
For Example: Right now I have tried:
IF(COUNTA(values) >= 1, "• “) & ARRAYJOIN(values,”\n• ")
This still outputs if there are empty values in the roll up.
I have tried to also use the arraycompact() but then I have no way to use Substitute() to split up the values into a bulleted list.
Any help will be greatly appreciated!
Thanks!
Solved! Go to Solution.
Apr 11, 2022 07:54 AM
Oops. I forgot to replace the second COUNTALL with ARRAYJOIN.
As for still counting the blanks, what is the field type that is being rolled up, and could the blank values look blank but really have a hidden space?
Apr 09, 2022 11:26 PM
Welcome to the Airtable community!
Try nesting ARRAYCOMPACT inside COUNTALL and inside ARRAYJOIN. This removes the blanks before counting or joining the values.
IF(
COUNTALL(ARRAYCOMPACT(values)),
"• " & ARRAYJOIN(ARRAYCOMPACT(values),"\n• ")
)
Apr 11, 2022 07:25 AM
Thanks for the suggestion! For some reason @kuovonne that outputs the number of items but it not as list of the values. It still also counts the empty ones :confused:
Apr 11, 2022 07:54 AM
Oops. I forgot to replace the second COUNTALL with ARRAYJOIN.
As for still counting the blanks, what is the field type that is being rolled up, and could the blank values look blank but really have a hidden space?
Apr 11, 2022 09:50 AM
It worked! And it ignored the blanks! Thanks for your help!