What is the easiest way to mass update cells in a new column? In Sheets or Airtable this would be a drag down, but Clay doesn't have Specific example is creating a "URL Cleanup Group" column and wanting to apply "1" to the first 500 cells in the column, then import more records and apply "2"
To mass update cells in a new column, you can add a new column by scrolling to the right of your table and selecting "Add column" or using the dropdown menu for an existing column to choose "Insert right" or "Insert left". When creating the column, specify the data type as "Number" since you want to apply numerical values like "1" and "2". For mass updates, you can directly edit individual cells by copying and pasting values, or create formulas to apply values systematically. For your specific workflow of applying "1" to the first 500 cells and then "2" to subsequent records, you could use a formula approach when setting up the column to automatically assign values based on row position or import batch. Are you looking to apply these values based on the order of rows in your table, or do you need to group them based on when the records were imported?
Group based on when records were imported
For grouping records by import batch, create a formula column that assigns values based on import timing. When you import CSV data, you can add it to your existing table using Actions → Import → Import from CSV → Add to existing table. Set up your "URL Cleanup Group" column as a Number type, then use a formula that checks row position or import date to assign "1" to your first 500 records and "2" to subsequent imports. You can also manually update the column values after each import by selecting the range of new rows and applying the appropriate group number.
Why hasn't Clay added a fill handle yet? Seems like one of the biggest useful things missing from Clay's spreadsheet functionality
Clay focuses on data enrichment and automation rather than traditional spreadsheet functionality like fill handles. Our platform is designed around columns that process data through formulas, enrichments, and integrations rather than manual cell manipulation. For mass updates, you can use formulas in columns to automatically populate values based on conditions, or leverage our auto-update feature to process new rows automatically when they're added to your table. What specific workflow are you trying to accomplish with mass cell updates that might benefit from an alternative approach?
Hey, thanks for reaching out! I replied in the other thread, so I’ll close this one. However if you would like to leave any additional information here as well, I'll relay this to our product owners as well. Any additional context is welcome, so we can keep your situation in mind as we build out the roadmap.
Specific example is creating a "URL Cleanup Group" column and wanting to apply "1" to the first 500 cells in the column, then import more records and apply "2"