I am trying to use a calculated column to grab info from my columns and add the ID number on the end and pad it. I can get most of this to work, as I build it up but the ID number at the end does not show. Can anyone have a look and help with this? Thank you
=CONCATENATE(("123456-"&[Group]&"-"&[Area (IA)]&"-"&[Area (S)])&"-"&,REPT("0",6-LEN([ID])),[ID])
looking at trying to get "123456-Mec-100-200-000001"
Project number (hard coded for each project)-Group (Choice column)-Area IA (Choice column)-Area (S) (Choice column)-000001 (max 6 digits including the ID number)
Working with SharePoint 2010.