Remove spaces when concatenated field is blank [Field]@2row + " "

Scottd ✭✭✭
edited 05/23/23 in Formulas and Functions

When using Join or concatenating via the + sign I am adding a space after each field. Sometimes not all 8 fields have a value but the space is still entered for blank fields. It looks good in smart sheet, but when you go to export it is has a space for each blank field. I would like to remove the extra spaces so when exported it can be used with no editing.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!