Can I set up auto number with several different prefixes and different starting number?

CTops

I am taking over several existing and upcoming projects and have set up sheets for each project and an overview sheet for all existing projects. I am now at the point where a number of new one are staring and would like to auto-number them however the system that was set up is each type of project has a different starting number e.g house 1000 flat 2000 bungalow 3000 and so on, the issue is we may be up to 3065 in bungalow and 1235 in house - is there an easy way to auto number new projects as they come in?

Paul Newcome

You would need to use an auto-number column with no special formatting to track the order the rows are added and then use a COUNTIFS/IF combo to get the number.

=COUNTIFS([Auto-Number]:[Auto-Number], @cell<= [Auto-Number]@row, Type, Type, @cell = Type@row) + IF(Type@row = "Flat", 1000, IF(Type@row = "Bungalow", 2000, 3000))