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
Answers
-
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!
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!