I've created a Sharepoint list and would like each record in the list to have a unique identifier, starting with
I am leveraging the Site generated ID column (Hidden in the list view), by creating a new calculated column called `CASE ID' and using formula:
Whenever I refresh the formula it works, it will show CASE-01, CASE-02, CASE-03, but the next day it will revert back to CASE-00, CASE-00, CASE-00.
I do have a work-flow running in the back to refresh 'today' date (not sure if that has anything to do with it?)
Does anyone have a solution so that once CASE-01 is set, it doesn't revert to CASE-00?