Merging column Formulas with different FIND options


I'm trying to build a consolidated formula where i want to split the numbers from the x1 column without any separator as shown in LEFT & RIGHT columns, so that i can calculate the unique count (Column Count).

I am facing issue with merging of the formulas as shown in column Formula in order to separate the x1 column values either by "+" or "-".

Can i get some help on this please.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!