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 project number to be P21001, P21002, P21003… P for our name, 21 for Year, and 001 for the unique project number. We also want 2020 projects to be P20001, etc.
I found in the forum the formula for getting the YY: MOD(YEAR(CREATED_TIME()), 100)
Can someone help me figure out how to make the formula that will work for any year in this way?
Thanks so much in advance!!