Hey all, we are trying to get unique project numbers for our airtable. (We are managing video projects). Last year, we just did an auto number and had a formula to add 20000 to that number. 20001, 20002, 20003, etc. This year, we want the unique p...
It’s not perfect, but you could create a manual rule every year that would subtract the previous years total from the automatic number generated for this years projects.
