Left and Find Formula Issue
Are there any glaring issues with the following formula?
=LEFT([AR - Run 1 Size]@row, FIND("""", [AR - Run 1 Size]@row) - 1)
I'm trying to return the leftmost text that occur before the quotation mark. For example,
Original string: 2" InchFisher399
I want just the number 2
I just get #UNPARSABLE
Best Answer
-
I figured it out. It didn't like looking for the quotation mark, so I changed it to look for the space after the quotation mark and then subtract by 2.
=LEFT([AR - Run 1 Size]@row, FIND(" ", [AR - Run 1 Size]@row) - 2)
Answers
-
I figured it out. It didn't like looking for the quotation mark, so I changed it to look for the space after the quotation mark and then subtract by 2.
=LEFT([AR - Run 1 Size]@row, FIND(" ", [AR - Run 1 Size]@row) - 2)
-
Thanks for posting your solution! 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!