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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!