Trying to get data using the RIGHT formula

cabbsman
cabbsman ✭✭✭✭
edited 02/28/24 in Formulas and Functions

I have the following data where I am trying to parse the (ISPHUBS-6AAA) from the string below.

Assets 1 = ORRR39-ORMOOO-BEACH (ISPHUBS-6AAA)

I use the RIGHT formula ...

=RIGHT([Assets 1]@row, FIND("(", [Assets 1]@row))

But I get the following string returned

Result = -BEACH (ISPHUBS-6AAA)

How do I get just the (ISPHUBS-6AAA) returned?

Thank you!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!