Combination of PARENT and LEFT function

Emily NZ

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

Jon Mark H

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

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! :)