Formula Help Needed to Remove 0 From Results

Hello Smartsheet Community!


I need some help to better understand what is happening. Why are only some of my results generating a leading 0 in front of my text?


I have a multi-select column with a variety of text values for more than 20 groups. In the same sheet, but in different columns, I have written out a formula to pull out the specific set of values for each group. I am experiencing the same issue with all of my formulas where a leading zero is popping up for some of my results.


Here is an example of my formula:

=IF(CONTAINS("Group 1 - Position 1", Positions@row), "Group 1 - Position 1" + CHAR(10)) + IF(CONTAINS("Group 1 - Position 2", Positions@row), "Group 1 - Position 2" + CHAR(10)) + IF(CONTAINS("Group 1 - Position 3", Positions@row), "Group 1 - Position 3" + CHAR(10))


Thanks in advance!

Sandra

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!