Skip to main content
add tag
Link
Julie_MSFT
  • 4.3k
  • 1
  • 6
  • 11
Source Link

Calculated column formula help

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