Sure. I created two calculated fields Project NumberCONCAT(RIGHT(YEAR(Entry Date),2),"-",Reference Number,"-",Project Team Code)Project Team CodeIF(Group ID="GROUP1IDNUMBER","GROUP1CODE",IF(Group ID="GROUP2IDNUMBER","GROUP2CODE"))This can go on for hundreds of groupsBe sure to include every necessar...