Count file names only

Adrienne Van Halem · 11/19/20

I'm trying to create a unique ID for documents. I would like to generate a unique number for each Category (in "Abv") but I'm struggling to not count the parent rows.

My current formula is: =SUM(COUNTIFS(Auto:Auto, <Auto@row, Abr:Abr, Abr@row) + COUNTIFS(Auto:Auto, Auto@row, Abr:Abr, Abr@row))

The formula abode had been in "Count" but was counting the green and bolded rows too (which are folders, not files). In the yellow box is manually keyed in how I'd like the formula to create the numbering so the "New Document #" column will produce a unique number that starts at 1 for each Category eg. "MO", "SE"

Mark Cronk · 11/19/20

Good afternoon, You could add a helper column to flag or a checkbox parent rows. Then use a COUNTIFS() that contains the helper column criteria -- Helper:Helper, =0

Mark

Mark Cronk · 11/19/20

Good afternoon, You could add a helper column to flag or a checkbox parent rows. Then use a COUNTIFS() that contains the helper column criteria -- Helper:Helper, =0

Mark

Adrienne Van Halem · 11/19/20

https://community.smartsheet.com/discussion/comment/269488#Comment_269488

Thanks so much! I added a helper column with =IF(COUNT(CHILDREN()) > 0, 1, 0)

and then changed my Count column to be

=SUM(COUNTIFS(Auto:Auto, <Auto@row, Abr:Abr, Abr@row, [Helper2]:[Helper2], =0) + COUNTIFS(Auto:Auto, Auto@row, Abr:Abr, Abr@row))

It still returns a 1 on the Parent folders but my statement in the Doc # column just doesn't return it.

Mark Cronk · 11/24/20

Hi again @Adrienne Van Halem,

In your count column try:

=if(Helper2@row=1,"", COUNTIFS($[Abr]$1:[Abr]@row, =[Abr]@row, $[helper2]$1:[helper]@row, =0))

Your helper2 formula should be =IF(Count(Children())>0,1,0)

Your count column should return a series of numbers starting with 1 for each Abr category (MO & SE).

Work?

Mark

Count file names only

Best Answer

Answers

Help Article Resources

Categories