Trying to get data using the RIGHT formula
I have the following data where I am trying to parse the (ISPHUBS6AAA) from the string below.
Assets 1 = ORRR39ORMOOOBEACH (ISPHUBS6AAA)
I use the RIGHT formula ...
=RIGHT([Assets 1]@row, FIND("(", [Assets 1]@row))
But I get the following string returned
Result = BEACH (ISPHUBS6AAA)
How do I get just the (ISPHUBS6AAA) returned?
Thank you!
Best Answers

I figured it out!
=RIGHT([Assets 1]@row, FIND(")", [Assets 1]@row)  FIND("(", [Assets 1]@row) + 2)
This can be closed.

That works... the more traditional way is to subtract the location of the character you are searching for from the total length and add a digit back.
=RIGHT([Assets 1]@row, LEN([Assets 1]@row)  FIND("(", [Assets 1]@row) +1)
Answers

I figured it out!
=RIGHT([Assets 1]@row, FIND(")", [Assets 1]@row)  FIND("(", [Assets 1]@row) + 2)
This can be closed.

That works... the more traditional way is to subtract the location of the character you are searching for from the total length and add a digit back.
=RIGHT([Assets 1]@row, LEN([Assets 1]@row)  FIND("(", [Assets 1]@row) +1)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!