Removing commas if a field being joined is blank?

MTaber ✭✭
edited 04/18/24 in Formulas and Functions

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 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, ",")


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!