March 14, 2023
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!