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?

Find more posts tagged with

Accepted answers

Paul Newcome

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)

All comments

Paul Newcome

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)

JBolan

YES! Thank you @Paul Newcome ! this one was really bugging me - I appreciate your help!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.