Primary Column Formula Issue


Im trying to create a formula where the primary column populates what is in one of 6 possible columns. I have a pretty simple formula right now (=Column Option 1 + Column Option 2 + Column Option 3 + Column Option 4 + Column Option 5 + Column Option 6). The problem is, Im getting a leading zero when the column thats filled ISNT column 1. What would be the best way to resolve this?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!