Using a formula to subtract out a Contact

Afleisc ✭✭
edited 09/15/22 in Formulas and Functions


Is it possible to use a formula that when given a contact cell with multiple assigned contacts, and a secondary cell with one assigned contact, will SUBTRACT that contact from the first cell? So in practice it would look like this:

Cell 1: Contact1, Contact2, Contact3

Cell2: Contact2

Cell3: Use a formula that subtracts out Cell2's value from Cell1's value, returning the values of only Contact1 and Contact3

Hopefully that all makes sense, and I apologize if this is a simple formula question but I've searched through formula/function helps and past threads and can't seem to locate guidance. Any assistance would be greatly appreciated.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!