Custom Auto-Populate Row ID with different references

Lani

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.

Example:

Project X

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.

Paul Newcome

How are the new rows being added?

Lani

I was hoping to have it add rows with a form but because I have multiple companies, I have created each CO to be a sub-item under the appropriate company. Therefore, I will be adding rows manually.

Lani

I was hoping to have it add rows with a form but because I have multiple companies however, because I have each company as a line with sub-items under with each CO, I am going to input the rows and information manually. I attached an example.