Removing commas if a field being joined is blank?

MTaber

Have a "Reason for DQ" field that aggregates responses from hidden helper columns (finds fields with "bad" conditional formatting).

What it looks like unhidden:

I'm so close...but so far...how do I keep the commas separating data but remove them if the fields are blank? Forumula being used below:

=JOIN([Pre-Bid helper]@row:[Crimes Helper]@row, ",")

parulmishra

Hi @MTaber

Try using this formula

=JOIN(COLLECT([Pre-Bid helper]@row:[Crimes Helper]@row, [Pre-Bid helper]@row:[Crimes Helper]@row, NOT(ISBLANK(@cell))), ", ")

parulmishra

Hi @MTaber

Try using this formula

=JOIN(COLLECT([Pre-Bid helper]@row:[Crimes Helper]@row, [Pre-Bid helper]@row:[Crimes Helper]@row, NOT(ISBLANK(@cell))), ", ")

MTaber

Worked beautifully, thanks @parulmishra