Formula for Find

Options

Hello-

Is there a formula I can add on this below. I need to get the Customer's name, like the one on the 5th row. I'm getting Invalid value. Thanks.

=MID([Opportunity Name]@row, FIND("~", SUBSTITUTE([Opportunity Name]@row, "-", "~", 5)) + 1, FIND("~", SUBSTITUTE([Opportunity Name]@row, "-", "~", 6)) - 1 - FIND("~", SUBSTITUTE([Opportunity Name]@row, "-", "~", 5)))

Thanks.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!