+6I need to create a report to find all records where a 'multi-select text' field is not blank - something has to be checked. If I choose 'equal to <blank>, it still shows all records, not just the ones that have something checked in that field. There are many choices so I don't want to write a bunch of OR statements choosing each option. Any ideas?
Hi Amy,
One pretty simple solution would be to create a formula-checkbox that checks to see if the multi-select field is empty. I used the following field to check...
If(ToText([Multiselect Field])<>"", true, false)
Then you could add this checkbox to the filters of the report. You could also make it a report formula if you would like. I hope this helps! Please let me know if you have any questions or I am misunderstanding the issue!
I agree with Tylers solution, but it may be worth checking with Customer Support as it seems like it would be a bug if the filter does not recognize a multi select as blank? If it is a bug, worth reporting it so it goes on their list to fix.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
