Calculated column formula help

Question

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

Answer 1

Please following steps:

1.Create a Single line of text column named "Counter"

2.Create the first Calculated column named "Current Date"

Formula:

=TEXT(TODAY(),"ddmmmyyyy")

3.Create the second Calculated column named "Tracker number"

Formula:

=CONCATENATE("TN",[Current Date],[Counter])

4.If you don’t want to show "Current Date" column, you can choose to hide it