Record ID, restart at 1

[Lizbhernan]

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.

[BransonJamesFarley · Accepted solution]

Hi! I Added in a multi row formula for you. Let me know if this works!

[Lizbhernan]

Hi @BransonJamesFarley this worked! Thank you so much for your help!