I have a request to generate a tracker number when a new item is created to a list based on the below logic:
- The number format is "TN" + CurrentDate(ddMonYY format) + Counter. eg: TN18Oct2101
- 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?