Combination of PARENT and LEFT function

Options

Kia ora koutou,

I'm wanting to combine the PARENT and LEFT functions to copy the first 6 characters of the Parent cell as a label for the Child cells. In my work, each parent cell starts with a code and then has a sentence (12+ words) as the title. I'd really like to be able to copy just the code e.g. A1.2.3 but not the sentence. I have no problem with the PARENT function on it's own but get an #UNPARSEABLE result when I combine it with the LEFT function. I'm not sure where I'm going wrong, appreciate your advice in advance! Below is the formulas I've tried:

=PARENT(LEFT([Primary Column]@row),[6])

=LEFT((PARENT([Primary Column]@row)),[6])

Ngā mihi,

Emily


Tags:

Answers

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    Options

    Hey @Emily NZ

    I may be mistaken, as I'm not sure on how the formulas for NZ may differ from the USA - but I believe your formula should just be:

    =LEFT(PARENT([Primary Column]@row), 6)

    (i.e. no "[]" around the number)

    Let me know if that works out or not - or if you need help with anything else!

  • Emily NZ
    Options

    Thanks Jon! That works perfectly!!

    I can see now that I was adding in the unnecessary brackets from the formula example, and that it says the brackets are optional in the Arguments section. Good to know for next time! :)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!