Pulling a name out of a columnq


I have a customer column on sheet 1 (ie. "John Doe") and a customer column on sheet two that displays there company name as well (ie. "SSS-John Doe")

On sheet one I am writing a formula to reference sheet two, so far I have =COUNTIF({PBR Customer}, FIND("John Doe", @cell) > 0)

This works but I want it to automatically pull out the name from the customer column on sheet one vs having to type it into the quotations.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!