I have columns I want to be able to select several values from a dropdown. The issue is when I select 2 values from the dropdown and try to ‘manually backspace’ on the first value (to remove it) – it instead removes the second value, and keeps the first. If I have more than 2 values, and try to remove the first value, my sheet will throw a Stop Error (this – I am ok with – but if there’s a more elegant solution to accomplish my goals – please propose it).

I have columns I want to be able to select several values from a dropdown. The issue is when I select 2 values from the dropdown and try to ‘manually backspace’ on the first value (to remove it) – it instead removes the second value, and keeps the first. If I have more than 2 values, and try to remove the first value, my sheet will throw a Stop Error (this – I am ok with – but if there’s a more elegant solution to accomplish my goals – please propose it).