Auto number when box is checked
question on how to generate a number when a checkbox is checked. This seems simpler than other peoples asks, but I can't seem to make it work for me. screenshot is the area that needs to be addressed. I want the [PO #] (currently set to auto-number every row)to generate the next number ONLY when the [PO needed?] is checked. Is there a formula that can do this? or will I have to upgrade to Business plan to get the ability to have this checkbox change another cells value?
These values are entered by a form.
The formula listed is the closest I can get within my knowledge!
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!