Combination of PARENT and LEFT function

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

Find more posts tagged with

Formulas

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.