Labeling Rows in Filtered Views of a Master Table

Jay H. · 2025-11-27T19:08:39.292Z

Hi all, I have a master table that I run in segments. Is there a way in a text column to only apply the text to the rows in the filtered view? (I.e: Filter view 1st run: Label them all as 1st run, Next 200 rows: label as 2nd run) RIght now, if I change the text it changes for all cells in that column

Labeling Rows in Filtered Views of a Master Table | Clay

12 comments

· Sorted by Oldest

Bharat D.
·
·
Hey - there are two possible alternatives
1.
You can filter a certain number of rows for example: the first 100 and run them. If you click on the row numbers you can see this option.
2.
Insert a formula column and run an AI formula saying " assign Batch 1 or Batch 2" randomly. You will not get an exact split.
Jay H.
·
·
Thank you Bharat! Editing a 'Text' column on a filtered view allows me to add a text value to the column. However, when I unlock the filters the entire column is filled. How do I do it like excel where i filer, add the manual value, and then unfilter without any issues?
Bharat D.
·
·
How many rows are there ?
Jay H.
·
·
~6000
Bharat D.
·
·
Do you need to randomly split them?
Bharat D.
·
·
Or is it based on some logic ?
Jay H.
·
·
We are just enriching the rows in batches of 500 and want to keep track of what we've run, and what "batch" it is
Bharat D.
·
·
Makes sense. Then I recommend using the formula option for this. Randomly assigned 1-6 numbers
Honourable A.
·
·
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.
Bharat D.
·
·
The above option is great!!
Jay H.
·
·
Yeah thank you both! Honourable A. this is what I am doing right now - was wondering if there was a quicker way to do it is all!
kushagra t.
·
·
round robin assignment to create batches then filter based on the assigned value save as a filtered view say batch 1, batch 2, run the saved views separately will keep things clean and easy to check as well
❤️1

Bharat D.
·
·
Hey - there are two possible alternatives
1.
You can filter a certain number of rows for example: the first 100 and run them. If you click on the row numbers you can see this option.
2.
Insert a formula column and run an AI formula saying " assign Batch 1 or Batch 2" randomly. You will not get an exact split.
Jay H.
·
·
Thank you Bharat! Editing a 'Text' column on a filtered view allows me to add a text value to the column. However, when I unlock the filters the entire column is filled. How do I do it like excel where i filer, add the manual value, and then unfilter without any issues?
Bharat D.
·
·
How many rows are there ?
Jay H.
·
·
~6000
Bharat D.
·
·
Do you need to randomly split them?
Bharat D.
·
·
Or is it based on some logic ?
Jay H.
·
·
We are just enriching the rows in batches of 500 and want to keep track of what we've run, and what "batch" it is
Bharat D.
·
·
Makes sense. Then I recommend using the formula option for this. Randomly assigned 1-6 numbers
Honourable A.
·
·
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.
Bharat D.
·
·
The above option is great!!
Jay H.
·
·
Yeah thank you both! Honourable A. this is what I am doing right now - was wondering if there was a quicker way to do it is all!
kushagra t.
·
·
round robin assignment to create batches then filter based on the assigned value save as a filtered view say batch 1, batch 2, run the saved views separately will keep things clean and easy to check as well
❤️1