Custom Auto-Populate Row ID with different references
I am needing to create a Change Order (CO) sheet for one project but has more than one company with change orders. I am looking to see how I can auto populate each row with a change order # that references each company.
Three companies: A, B, C.
For Company A, I would like each CO line item to be identified as CO-Project X-Company A-001, CO-Project X-Company-002, and so on.
Then, similarly, Company B would include CO-Project X-Company B-001, CO-Project X-Company B-002, an so on.
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!