How to Copy Values Down a Column in Excel or Google Sheets | Clay

How to Copy Values Down a Column in Excel or Google Sheets

might seem like a silly question, but anyone know how to simply copy down a value on a column (similar to excel/google sheets)? For example, row 1 has a value of "Linkedin" inside the Campaign column, I just want to copy this down for the entire column, but not preset all rows to have this value.

✅1

16 comments

Nick S.
·
·
https://app.clay.com/workspaces/207112/tables/t_J1Pjsw91Cohi/views/gv_RaCg3zMEX434 Checkout the "List Name" column
Clay Team
APP
·
·
Hi, thanks for getting in touch! check this:
19021389-bd82-4ed4-8968-eaff679be991.png(17 kB)
Clay Team
APP
·
·

5b597297-1d2e-48a2-a8ed-a912fc753c14.png(5 kB)
Nick S.
·
·
that is setting it for the entire column though
Nick S.
·
·
some data will need a different value
Frederik H.
·
·
Hey Nick S., what you also could do, is using a formula and then using the AI formula to write the values into a new column.
:thumbsup_all:1
Frederik H.
·
·
1.
Create new column with Data Type Formula
2.
Describe your formula. I suppose it will be an if then else statement.
For example: If the column /Campaign contains "Linkedin" then write Linkedin, if contains "xyz" then "xyz" 3. Generate the formula and check your results If you need help let me know, I can assist further if needed!
:thumbsup_all:2
Nick S.
·
·
Thanks Frederik H. - should be ok for now, I think I'm just gonna create the campaign column before I import it, I have multiple imports going into the same table and wanted a way to differentiate the person's campaign type.
Frederik H.
·
·
Got it! But you can do a lot with the AI Formula feature of Clay. So if you use the logic I mentioned, you should classify each row by using the formula!
Nick S.
·
·
is there any other way to do it though? I don't think the AI Formula feature won't work for me as I have one import list table, all imports go into that, and I need to label each import row as "xyz" and then the one batch as "abc" - the only way I can think of is by assigned the campaign value inside clay based on time uploaded, but I'm wondering if there's a better solution than that, otherwise I might have to resort to adding the column in a CSV then mapping it to my clay table, then mapping it on my write to column ect ect
Clay Team
APP
·
·
you can do this with formulas too, if cell contains "xyc" then...
Nick S.
·
·
yes but I have nothing to base the formula on right now (no differentiators in the imported list) which is why I think I'll probably need to just add a column before I import it
Clay Team
APP
·
·
what are you trying to filter?
Nick S.
·
·
nothing, I'm just trying to add values in bulk in a column manually if possible
Clay Team
APP
·
·
Then formulas with conditionals, but as you are telling me, there are no inputs for that, the best approach would be doing this in the csv before the import
:thumbsup_all:1
Nick S.
·
·
Frederik H. Clay Team really simple hack for this: copy down the value you want in your target row numbers down in excel/sheets first, and then simply paste over 💡