To check all cells in a column, copy the formula down to other rows: Tip. Here is the solution. If value or value_if_na is an empty cell, IFNA treats the cell's value as an empty string (""). In this example we will use hasOwnProperty method of json object that will help to check if key exists or not in jquery. Currently I am able to input into A1, add the value to the next empty row in C and clear A1 after. getResponse(responseId) FormResponse: Gets a single form response based on its response ID. We use array .indexOf () to find out whether the element is present in the array or not.