Formula Help


I have one column with a person's first name, then I have another column that I want to be just the first initial of the previous column's first person's name.

Instead of typing in the first initial every time, I want to know if there is a formula I can put in the initial column??



  • Chris McKay
    Chris McKay ✭✭✭✭✭✭

    Hi Manda,

    Assuming I understand you correctly, you just want the first letter from your First Name column to appear in your First Initial column? If so, enter this formula in First Initial and copy down as far as required:

    =LEFT([First Name]1,1)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!