Bulk Pasting Values in Rows in Clay: A Step-by-Step Guide

Ammar Kamran · 2025-10-10 00:24:03.602382+00

Is there a way to bulk paste values in a row in Clay. So I want to populate every row below 100 and fill that row with a 2 for a specific column. How can I do that?

Bulk Pasting Values in Rows in Clay: A Step-by-Step Guide | Clay

Ammar Kamran
·
·
how would I do it via row numbers? Can you share that formula?
Ammar Kamran
·
·
is there a way to give the rows a count? because that formula is not working Like can I create a column just to give me a count starting from 1
Ammar Kamran
·
·
what formula will I use for this
Ammar Kamran
·
·
I used this Generate a sequential number starting from 1 and it used this formula +(_?.uniqueId?.("")) however there are some issues. it starts with 2 then 4 then 6 and goes until 200 then it starts again with 2. How can I fix this. Either you give me the final formaula or you tell me what to prompt it.
Ammar Kamran
·
·
this isn#t working Create a row counter that starts at 1 and increases by 1 for each row it created this formula (_.toInteger({{rowIndex}})||0)+1 from that prompt which is invalid can you give me another way
Ammar Kamran
·
·
this formula worked but it started with 2 and then 4 and so on and it also starts with 2 again once reaching 198 How can I fix this
Ammar Kamran
·
·
there is no number generator under add columns
Ammar Kamran
·
·
I need to speak with a human
Ammar Kamran
·
·
Thanks for getting back to me Luca Prando (Clay). Apart from the counter formula. Could you please share some alternative solutions where I want to bulk past a value for a number of rows? This is done very easily in Google sheets but I couldn't figure it out in Clay.
Luca Prando (Clay)
·
·
Hi there, just to clarify, you mean bulk paste right?
Ammar Kamran
·
·
Yes exactly
Luca Prando (Clay)
·
·
Great question - for bulk pasting values in Clay, the easiest way is to copy the value you want, then select/highlight all the cells in that column where you want to paste it, and hit paste (Cmd+V or Ctrl+V). It'll fill all those cells at once, similar to how you'd do it in Sheets.
Ammar Kamran
·
·
I tried that but it didnt work
Ammar Kamran
·
·
Let me see again
Luca Prando (Clay)
·
·
Ok, let me know if its working now!

21 comments