Search for first empty row in Google Sheets

(Kanika Choudhary) #1

I want to search for the first empty row in my google spreadsheet and want to add data to that row. On creating the action to search for the row - I am able to select the column name but for the value to search - I want to look for the FIRST EMPTY CELL. How can I search for the value - EMPTY?

Capture2.JPG834×601 39.1 KB

(Sarah Palombo) #2

Hi Kanika :wave:,

It isn’t possible to search for an empty row. (unfortunately!)

The search tool works by searching for a specfic value.

The closest you’ll get possibly is to just use the Add a row. Although this will always add to the end of the sheet (rather than adding to the first empty column)

Not sure if that will help but I hope so ! Sarah :slight_smile:

(Kanika Choudhary) #3

Alright! Thanks a lot! :slight_smile:

(Kanika Choudhary) #4

While updating a row - the column values I am leaving as empty - is being updated with a null. Is there a way out where I can update only few of the column cells of a particular row without disturbing the other?

(Daniel Beckett) #5

@Kanika

It looks like you’ve reached out to the support team. We’ll take a look and answer over there. :slight_smile:

Thanks,
Dan

1 Like
(Anish Duggal) #6

@DanielBeckett

I think a solution to this would greatly benefit the public as well.

(Daniel Beckett) #7

@Anish

This particular issue seems to be a bug in our google sheets integration which has been raised with the development team for further investigation. The null values were a result of using a formulae within Google Sheets.

For the time being we recommend that any calculation actions be done using the Number service.