Matching Comma-Separated Values in a Cell Using Smartsheet Formulas
Hello Smartsheet community,
I have a consolidated tracking sheet that captures details like vendor names, contract numbers, invoice numbers, warrant numbers, and vendor numbers. In my current setup, if a vendor has multiple contract numbers, they are all contained within a single cell separated by commas. This pattern holds true for columns with multiple invoice numbers, warrant numbers, and so forth.
My question is about Smartsheet's formula capabilities: Can Smartsheet differentiate between individual contract numbers in a cell when they're separated by commas? More specifically, if I need to check for a match of a specific contract number in another Smartsheet, can the formula identify a match within a cell containing comma-separated values, or would each contract number need to be in its own individual cell for this type of validation?
Help Article Resources
Check out the Formula Handbook template!