I'm starting w/a criteria field, and then trying to find a first letter after the space.
So if the drop down option Time Away (Workman' Comp, FMLA, STD, etc.) is met, then I need to look at the name column, where names are listed as First Last, and grab the first letter of the last name. Alternatively, I could reformat the name to be Last, First via formula, and then just capture the first letter? Either way, some names aren't written like real names, ex "Market Data Request", but that one would be filtered out if I use the if formula to only capture those w/specific drop downs......
This was my first attempt, which isn't working.
Then I tried a tip found here https://community.smartsheet.com/discussion/89379/last-name-first-name which also isn't working.
Help?
Best Answer
-
To grab the first character after the first space, you would use something like this:
=MID([Name Column]@row, FIND(" ", [Name Column]@row) + 1, 1)
Answers
-
To grab the first character after the first space, you would use something like this:
=MID([Name Column]@row, FIND(" ", [Name Column]@row) + 1, 1)
-
YES! Thank you @Paul Newcome ! this one was really bugging me - I appreciate your help!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!