How to create a formula to pull the first part of an order number into an adjacent column

Hello!

I am struggling to create a formula to pull the first part of an order number (our internal agency numbers) into a separate column so I can see how much each agent sends in each month. Screenshot of the order number below:

Best Answer

  • Isis Taylor
    Isis Taylor ✭✭✭✭✭✭
    Answer ✓

    @cmseeton Is this what you are trying to accomplish?

    If so use this formula in the Agent column.

    =IFERROR(LEFT([Order Number]@row, 4), "")

    Isis Taylor

    🎓️ Core App and Project Management Certified 🏅

    🌟Peer Connect, Mobilizer, and Early Adopter Program

    Business Analyst Senior

Answers