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

First create each of the different formulas. Then combine them using IF statements.
=IF(FIND("", [x1]@row) > 0, insert_""_formula, IF(FIND("+", [x1]@row) >0, insert_"+"_formula, insert_"neither"_formula))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!

Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!
Answers

First create each of the different formulas. Then combine them using IF statements.
=IF(FIND("", [x1]@row) > 0, insert_""_formula, IF(FIND("+", [x1]@row) >0, insert_"+"_formula, insert_"neither"_formula))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!

Great! Its working. thanks Paul for the quick support.

Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.9K Get Help
 379 Global Discussions
 210 Industry Talk
 441 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 300 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!