LEFT Formula

ginamt3 ✭✭✭✭
edited 04/12/24 in Formulas and Functions

I'm looking to capture the characters to the left of the space "-". Is there a way to do it so that when there are only 2 characters I need that it doesn't give me "MO -"

=LEFT([Job Name]@row, 4)

GSID - South Warren Ave PH1

MO - Haydinger Kitchen

Best Answer

  • Courtney S.
    Courtney S. ✭✭✭✭✭
    Answer ✓

    I think using the FIND function inside your LEFT function would work.

    FIND Function | Smartsheet Learning Center

    This formula should find the starting position of the " - " portion of the Job Name: =FIND(" - ",[Job Name]@row)

    So if you put that inside the left function, you should get the characters to the left of that.

    =LEFT([Job Name]@row,(FIND(" - ",[Job Name]@row)-1))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!