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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!