Forum Discussion

gkolapp's avatar
gkolapp
Copper Contributor
Oct 18, 2021

SharePoint Calculated column formula

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

No RepliesBe the first to reply

Resources