Auto-Numbering Parents, But Not Children

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?
Best Answers
-
Hi @Nicole J
[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)
-
Hi @Nicole J
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.
Answers
-
Hi @Nicole J
[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.
-
Hi @Nicole J
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67K Get Help
- 442 Global Discussions
- 154 Industry Talk
- 503 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 79 Community Job Board
- 512 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!