Thursday, October 15, 2015

how to auto increment column in share point list calculated column?

Calculated formula:



=CONCATENATE("RR-",REPT(0,4-LEN(ID+1)),ID+1)



Result

RR-0001
RR-0002
RR-0003
RR-0004
RR-0005



No comments:

Post a Comment