set field based on checkbox selection

[technoranger]

I need to set the content of a field based on a checkbox selection. For example, I have a field with checkboxes from a value list, think seven dwarfs. If Grumpy is checked, alone or in combination with other dwarfs, I need to set the content of a text field to "Put your happy eyes on". I can do that with a Case function, but I either get the text when any dwarf is checked, or when Grumpy is checked alone. I'm looking for a calculation like Case(Dwarf Includes but is not limited to "Grumpy"; "Put your happy eyes on";...

Any ideas?

[Stuart Taylor]

If its grumpy and another you could test for ¶ aswell.

[comment]

Check out the FilterValues() function.

[technoranger]

Thanks....the FilterValues seemed to work. What I wrote was Case( FilterValues ( Dwarfs ; "Grumpy" ); "Put your happy eyes on"......

That seems to work, but is that what you intended? I spend a lot of time muddling through.

R

[comment]

I don't think it can work that way. It needs to be:

Case ( not IsEmpty ( FilterValues ( Dwarfs ; "Grumpy" ) ) ; "Put your happy eyes on" )