Remove spaces when concatenated field is blank [Field]@2row + " "
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.
Help Article Resources
Check out the Formula Handbook template!