SharePoint Calculated column formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2858603%22%20slang%3D%22en-US%22%3ESharePoint%20Calculated%20column%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2858603%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20request%20to%20generate%20a%20tracker%20number%20when%20a%20new%20item%20is%20created%20to%20a%20list%20based%20on%20the%20below%20logic%3A%3C%2FP%3E%3CP%3E1.%20The%20number%20format%20is%20%22TN%22%20%2B%20CurrentDate(ddMonYY%20format)%20%2B%20Counter.%20eg%3A%20TN18Oct2101%3CBR%20%2F%3E2.%20The%20counter%20increments%20for%20that%20day%20for%20all%20tasks%20created.%20The%20counter%20will%20be%20reset%20on%20everyday.%20For%20eg%3A%20TN18Oct2101%2C%20TN18Oct2102%2C...Then%20TN19Oct2101%3C%2FP%3E%3CP%3ECan%20this%20be%20achieved%20through%20a%20calculated%20column%3F%3C%2FP%3E%3CP%3EThanks%3CBR%20%2F%3EVenkat%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2858603%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I have a request to generate a tracker number when a new item is created to a list based on the below logic:

1. The number format is "TN" + CurrentDate(ddMonYY format) + Counter. eg: TN18Oct2101
2. The counter increments for that day for all tasks created. The counter will be reset on everyday. For eg: TN18Oct2101, TN18Oct2102,...Then TN19Oct2101

Can this be achieved through a calculated column?

Thanks
Venkat

0 Replies