Auto number when box is checked

First up - my experience says the specific question asked is not possible, as the auto number generates regardless of the check box or not (as you've figured out)

We compromised and decided not to worry if there were numbers missing between each one. We used the checkbox to add a number and hyphen to the front (e.g. 1496 became 2-1496). At one stage we were thinking about making the front number relative to the company or product, but decided against it.

As another compromise, if sequential numbering is required, you may want to forget about the auto number generation and use a max function within the PO field. e.g.

=IF([PO# needed?]@row = 1, max[PO #] + 1, 0) where [PO # ] = If([PO]@row ">" 0, [PO]@row, 0)

note, don't include the quotation marks around the "greater than" symbol. hope this helps?

Hi @Fabrication Team

I hope you're well and safe!

I recently developed a similar solution for a client.

I'd be happy to share an example. 

Please send me an email at andree@workbold.com, and I'll share it with you.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!