nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Static table row numbering regardless of sort/filter

Joachim Martin_ad9yp0

I'd like to show 1-N on my table regardless of sorting or filtering. I just want a visual indicator so that in meetings people can refer to "row 5" in the current view.

With Table Filter, it is Dynamic in that it recalculates after filtering, but not after sorting.

Any way to do this?

More info:

I'm looking for something like the =SUBTOTAL(3,B2:$B$2) rownumbering trick in Excel.

Basically regardless of sort or filter, I want the first row of the table to be numbered 1, second 2, etc.

Accepted answers

All comments

Sayed Bares [ServiceRocket]

@Joachim Martin I would suggest adding a new column to add the number for your dataset manually so this way it will always be static even if it is sorted or filtered.

Stiltsoft support

Hi @Joachim Martin ,

You may use standard Confluence numbered column option for your table and leave the numbering row type field inside the Table Filter macro blank.

Then if you sort or filter your table through the macro, the row numbers will remain as they are.

Joachim Martin_ad9yp0

I'm looking for something like the =SUBTOTAL(3,B2:$B$2) rownumbering trick in Excel.

Basically regardless of sort or filter, I want the first row of the table to be numbered 1, second 2, etc.

May not be possible but thought I'd ask the experts!

Stiltsoft support

Hi @Joachim Martin ,

The Table Spreadsheet macro supports the =SUBTOTAL(3, ...) function.

But it seems that I'm getting the idea wrong.

In my A column I have data and in the B column I try to create row numbers:

=SUBTOTAL(3,$A$2:A2)

=SUBTOTAL(3,$A$2:A3)

=SUBTOTAL(3,$A$2:A4)

I get 1, 2 and 3 that is correct.

But when sorting or filtering, the row numbers change and they are not static (both for Excel and Table Spreadsheet).

As I know, the =SUBTOTAL(3, ...) function equals the =COUNTA function that counts not empty cells in the range.

So, when sorting, only "strict" formulas work for me:

=SUBTOTAL(3,$A$2:$A$2)

=SUBTOTAL(3,$A$2:$A$3)

=SUBTOTAL(3,$A$2:$A$4)

What concerns filtering, even "strict" formulas break the numbering. I've found in Excel documentation that =SUBTOTAL(3, ...) function includes and =SUBTOTAL(103, ...) function ignores manually hidden rows. But the "filtered out" rows are always ignored. So, it seems that I get the correct behavior.

So, if you get the case to work, please share with us and future readers of this question.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

filter

ms-excel

table