hey just some thought process on what i would do - maybe it is what you looking for
- 1.
Export your table to Google Sheets
- 2.
Add a "Row ID" column — type 1, 2, then drag down to auto-fill the sequence
- 3.
Copy that column of numbers
- 4.
Back in Clay, create a new text column naming it Row ID and paste the numbers in it
Now each row has a static ID. Then use a formula like:
IF({Row ID} <= 200, "Run 1", IF({Row ID} <= 400, "Run 2", "Run 3"))
Bit of extra setup but gives you that Excel-like control where each row keeps its label.