I have a table i want to use to create quotes with. One of the fields is quote number. I would like to create a formula that creates unique 6 digit number with the last 2 digits of the year as the first 2 digits, followed by 4 digits. For example the first entry of 2018 would be 18000, followed by 180001 and so on. I can not use reference # as the identifier because i would like the last for digits to rollover at the start of the new year. For example the 140th entry of 2018 would be 180140 and the 140th entry of 2019 would be 190140. Any thoughts?