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