Autofill select box

1

Hi

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.

Thanks

2
  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
3

@Denis_Peshekhonov

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.

4

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