Workrequest creation

Workrequest num: =(LEFT(TEAM,1)&Year&CONCATENATE("WR-",REPT(0,4-LEN(incrementid)),incrementid))                     ex: A12WR-0251

(hear both incremented above through workflow only)

Year: =RIGHT(Filteryear,2)

Filteryear =TEXT(Created,"yyyy")

Incremented: (number field(number of decimal fields:automatic))

Incremented:through auto increment workflow

 Auto increment id workflow:

One more scenario for workrequest num creation

Workrequest no: =(Title&Filtermonth&Filterdate&Year&CONCATENATE("R",REPT(0,4-LEN(Autonumber)),Autonumber))                          ex: CSP042613R0000 (csp means title)

Filterdate: =TEXT(Created,"dd")

FilterYear:       =TEXT(Created,"yyyy")

Last two digits in year   year: =RIGHT(Filteryear,2)

Filtermonth :     =TEXT(Created,"mm")

Autonumber :Through designer workflow as specified above