I'm starting w/a criteria field, and then trying to find a first letter after the space.

JBolan

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?

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)

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. 👍️