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.
Example:
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.