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.


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!