Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to Remove Empty Value Option in Multiple Select Field Using a Formula

Topic Labels: Formulas
522 1
Showing results for 
Search instead for 
Did you mean: 

I have a multiple Select field that takes entries from a form. Often times it comes in with one of the options being empty or null in value. See Screen shot.
I’m trying to create a formula that removes this empty Value and the “,” for it. I’ve used all of the ARRAY formulas and they aren’t working.
Multiple select Has: ,17,18,19
I want the Formula Field to be: 17,18,19 (removing the first null value and the one between 18/19)

Screen shot shows both fields and that the empty field remains.

Screen Shot 2022-05-02 at 4.37.17 PM
Screen Shot 2022-05-02 at 4.37.17 PM

1 Reply 1

LEFT(FieldName,LEN(FieldName)-2*(RIGHT(FieldName,2)=', '))