Formula based on matching Primary Column Values

We use smartsheet for production tracking in beverage manufacturing. The primary column we use to create a batch ID for the associated production run: Date Produced + Brand Code + Run sequence (A,B,C, etc.) + Tank #. So an example would be: 03/15/21-RWO-A-01. RWO produced on 3/15, first run of the day and tank # 01. We end up with a lot of form entries tied to that batch ID, if I wanted to have a sequential number for each row added with the same Primary column value is there a way to do that without indenting to create a parent row?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!