Hello, I am working on a workflow in which I have to add a record ID that starts at 1 and depending on the company I need it to restart at 1 once the company changes. Does anyone know of a formula or tool I can use to help accomplish that? I have included a sample workflow and my desired results. Any assistance would be greatly appreciated.
