Auto numbering assets...

[JamesG81]

Hi, 

I am looking for a solution for my problem if possible?

What I am trying to achieve is auto numbering an asset in my lists. An example of the data is below.

I want to count the asset type and when I add another record it automatically assigns the next number as in the example below?

Any help will be greatly appreciated.

Asset Type	Asset Name
Calorifier	CAL 1
WHB	WHB 1
WC	WC 1
SINK	SINK 1
SINK	SINK 2
Calorifier	CAL 2
SINK	SINK 3
WHB	WHB 2
Calorifier	CAL 3

[Joseph_Seddik]

Welcome to the community!

You just have to count how many entries of the same type is already in the table and increment this count. For example:

COUNT(
  FILTER(tableName, [Asset Type] = [_ThisRow].[Asset Type])
  - LIST([_ThisRow])
) + 1

[JamesG81]

Hi Joseph,

Thanks for your suggested resolution.

The formula is giving me the same number for each asset as I add more
rather than each asset being consecutively numbered.

Kind Regards,

James Gaunt

[Steve]

Serial Numbers, If You Must - Google Cloud Community