Pull a first and last name from an auto email cell

Options

I'm looking to pull a first and last name from an auto populated email address from a form. I want to auto populate a "Requestor Name" column based on the email that was generated.

For example:

Email - Joe_Smith@gmailcom

Requestor Name - Joe Smith

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!