I have a "Formula - Checkbox" that I want to check only if a multi-select field has at least one item selected in it.

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

The formula I'm trying to use is this, on the Formula - Checkbox

If(ToText([Add ERP App]) = "",true, false)

But I have a feeling a multi-select field doesn't have an "empty" value per se. 

I have also tried the "IsNull" but that gave an error as well. 

Thoughts?

Photo of George

George

  • 30 Points

Posted 2 years ago

  • 0
  • 1
Photo of George

George

  • 30 Points
You can disregard. I'm not sure why I missed it the first time, but it was as simple as
If(ToText([Add ERP App]) <> "",true,false)

Thanks all the same.