I have requirement that to add auto-populated column in this format ” date_time_sequence no”. Here date will be selected by user in the form, time will be time of submitting and sequence no should be a no in 6 digits(ex:000001,000002) it should be incremented for every new request. Please help out to do this… Thanks & Regards, Prasad Kommuru

2 Answers 2


Try this :

CONCATENATE(TEXT([Column of Date],"DDMMYYYY"),"_",TEXT([Created],"HHMM"),"_",TEXT([ID],"000000"))

Formula in Excel

  • Will this not always add six zeroes before the ID, as opposed to having a total of six digits? Jul 24, 2013 at 10:39
  • this will ave total of 6 digits. You can verify the formulae in excel by providing the dummy values Jul 24, 2013 at 10:42
  • Yep - my formula gives 20130325000001 but Monica's also gives the time as was requested Jul 24, 2013 at 10:43
  • check the image i have attached Jul 24, 2013 at 10:44
  • For Sequence no, its not working. I want add sequence no as 000001 for first request, 000002 for second request, 000003 for third...like this final format is like (23072013_04:46_000001),(23072013_04:48_000002)...
    – user18348
    Jul 24, 2013 at 11:14

Something like:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.