Autofill select box


I have a column that based on the results of another column lookups another table, if its a result that doesn’t have a certain column in the table I would like it to auto fill the column with N/A rather than me having to manually select N/A.

Is this possible? I can’t work out how.


  1. Change your column type from Lookup to Select List.
  2. Use Filter() formula to fill list with values.
  3. Use Value for new rows option to set default value as N/A


I tried that and although it works, it adds N/A as soon as I add a new row. I only want N/A to show when the previous selection as no choices.

Could you provide some example, please? What is “previous selection”?