Affixing content to '=PARENT()xx'

Richard

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

Find more posts tagged with

Sheets

Formulas

Comments

Paul Newcome

You would need to use something along the lines of

=PARENT() + ".01"

Richard

Arh, thanks Paul

Cheers

Richard

Paul Newcome

No worries.

Richard

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

Paul Newcome

I haven't been able to find a fully automated way. Unfortunately every way I have found thus far requires some manual entry.

Paul Newcome

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

Richard

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

Paul Newcome

Go ahead and take a look now. Let me know what you think.

Richard

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

Paul Newcome

Good catch. Standby...

Paul Newcome

Sorry for the delay. We are getting some winter weather here. Anyway... Take another look. I am confident I have it set now...

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?