Clay Icon
Join the Community
02 Support

Easily Fill Empty Excel Columns with Yes Using Drag Method

Avatar of Joey W.Joey W.
·
·

Hey Team 🙂 If I have a row of empty columns and I wanted to change all of them to something simple like "yes" - is there a way to do this easily? (like dragging a cell downwards in excel)

2 comments

  • Avatar of Tom V.
    Tom V.
    ·
    ·

    You could click "create new column, formula, then use the use AI to write formula feature to say "If cell is empty in /XYZCOLUMN, print "YES"". Then click Hide on the original column Or you could see how many rows u have in Clay, then write in a Google sheet "Yes" in the same number of rows. Copy the google sheets column then paste it into the Clay column

    :sparkles-clay:1
    🙌1
  • Avatar of Joey W.
    Joey W.
    ·
    ·

    Perfect, this works 🙂 Thanks Tom!

    👊1