@TammyWe for the 4-digit number, we used the same process that we use for campaign number for a long time...
we created a report of all non-campaign projects - then used that report to manually assign the next campaign number. With the project number column sorted descending, with the highest numbe...