Affixing content to '=PARENT()xx'
Hi
I don't seem to be able to affix any text to =PARENT()? I want to have each of 6 child rows as:
=PARENT().01
=PARENT().02
=PARENT().03
=PARENT().04
=PARENT().05
=PARENT().06
Any thoughts?
Thanks
Cheers
Richard
Comments
-
You would need to use something along the lines of
=PARENT() + ".01"
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Arh, thanks Paul
Cheers
Richard
-
No worries.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Is there any way to make it self increment for the children under the parent?
and also, i see how you add, how could i remove to do this:
00.00.00 as the parent, and then increment the children below like:
00.00.01, 00.00.02, 00.00.03, 00.00.04. Ie I think you would need to remove the 00 and then replace with 01 and increment from there.
Thanks
-
I haven't been able to find a fully automated way. Unfortunately every way I have found thus far requires some manual entry.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
I found a way that requires 1 helper column for the first level of Hierarchy and 2 helper columns for every level after that. It does NOT hold up to sorting, but will hold up to the addition/deletion of rows as well as changes to the levels. The published link is below. The formulas are in row 1, row 2 is a buffer, and row 3 starts the actual sheet. If you were to delete rows 1 and 2, you would change any row 3 references to row 1 references ([Column Name]$3 becomes [Column Name]$1).
https://app.smartsheet.com/b/publish?EQBCT=4a032c46788b422db9224632dde79160
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Paul
That's brilliant, thanks.
Not wanting to push it! I like to do a preceding '0' on single digit numbers so that all numbers are two digit allowing me to go to 99. Is that something easily achievable. No worries if not, I'll take what you've given me. Much appreciated.
Thanks
Cheers
Richard
-
Go ahead and take a look now. Let me know what you think.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Paul
Looks good.... apart from where line 10 starts, I would of thought this should be '02.01' and line 14 be '02.02' and line 17 be '03.01' etc...
Thanks
-
Good catch. Standby...
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Sorry for the delay. We are getting some winter weather here. Anyway... Take another look. I am confident I have it set now...
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!