Auto-Number on Certain Rows

Are you able to provide more detail as to how exactly you want things populated and the layout of your sheet? Are you able to provide screenshots with sensitive/confidential data blocked, removed, or replaced with "dummy data"?

Ok. Next question...

Would you want it to be populated by row and only visible if needed? For example:

.

1

2

3

4

5

.

 But only 2, 3, and 5 are needed so you would see

.

2

3

5

.

Or would you rather see

.

1

2

3

.

I forgot that leaving gaps between rows in the forum doesn't work.

.

Here is what I meant to show... If you have 

1

2

3

4

5

and you only need 2, 3, and 5, would you want 

.

blank

2

3

blank

5

.

or would you prefer

.

blank

1

2

blank

3

blank

.

I am going to assume you knew what I intended and still want to go with the second option.

In that case, you would want to add in a text number column to house the numbering system and use the following:

=COUNTIFS([Column C]$1:[Column C]@row, NOT(ISBLANK(@cell)))

Seems like it's probably a simple fix. I'd be happy to take a look and fix it.

Can you maybe share the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)