SharePoint Calculated column formula

New 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