# Auto-Numbering Parents, But Not Children

✭✭✭✭
edited 08/20/24

I need to set up a means of having "auto numbers" (use the next number in the sequence) for "parent rows", but not "children rows". Is this possible?

Tags:

• ✭✭✭✭✭✭
```[ANC] =COUNT(ANCESTORS())
[PAN] =IF(ANC@row = 0, MATCH([Row ID]@row, COLLECT([Row ID]:[Row ID], ANC:ANC, 0), 0))
```

(Link to the published demo sheet)

• ✭✭✭✭✭✭

The solution below uses sheet summary fields, but you can replace them with the actual values.

=Prefix# + "-" + RIGHT([Zero Sup]# + [Parent Auto Number]@row, [ZS Len]#) + Suffix#

We can use the RIGHT function for zero suppression.

• ✭✭✭✭✭✭
```[ANC] =COUNT(ANCESTORS())
[PAN] =IF(ANC@row = 0, MATCH([Row ID]@row, COLLECT([Row ID]:[Row ID], ANC:ANC, 0), 0))
```

(Link to the published demo sheet)

• ✭✭✭✭

Thank you, so much!! This works great. Can you help me out with the [PAN] formula to:

• auto-lead with "Client - "
• display in six digits (000001, 000002, 000003, etc.)

So the [PAN] would spit out: Client - 000001, Client - 000002, Client - 000003, etc.

Many thanks.

• ✭✭✭✭✭✭

The solution below uses sheet summary fields, but you can replace them with the actual values.

=Prefix# + "-" + RIGHT([Zero Sup]# + [Parent Auto Number]@row, [ZS Len]#) + Suffix#

We can use the RIGHT function for zero suppression.

• ✭✭✭✭

Bingo. Thank you.

• ✭✭✭✭✭✭

Happy to help!😁

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!