Forum

Notifications
Clear all

Indicate a number which increments based on text (asset management)

2 Posts
2 Users
0 Reactions
143 Views
(@altinsalihi)
Posts: 1
New Member
Topic starter
 

Dears,

hope you are fine,

 

I want a formula (column C) which will update the cell based on the category which I will select in column B.

So, I want the first number to be default for example if the category is Containers then the asset should be 200000.

next, during the filling if I select again category, the next asset ID to be 200001.

 

in attach you'll find the table.

 

Thanks in advance!

 
Posted : 14/03/2023 10:55 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi,

No file attached.  Click on the Start Upload button after selecting the file.

regards

Phil

 
Posted : 14/03/2023 7:23 pm
Share: