Announcements
Hello,
I hope someone here will be able to help me out. I have a gallery filtering based on a few combo boxes. I would like these combo boxes to allow multiple selections. However, I noticed that my gallery is currently only filtering based on a single selection and not all selected values. The combo boxes are linked to an Excel spreadsheet, and they aren't choices columns. Please see my gallery formula below
Hi @SENDAN
the problem here is in the Filter formula.
The point is you have all OR conditions also between the 3 Comboboxes.
The Filter should be set differently.
Example:
Filter(
Source,
(Combobox 1 conditions) && // Same as AND
(Combobox 2 conditions) &&
(Combobox 3 conditions)
)
The ; is like a OR in the Filter
Can the user select multiple options inside each combo box?
Yes
Hi @SENDAN,
When the user selects multiple items in the combo box for filtering, do they want the query to:- match any of the selected items (OR)
- match all of the selected items (AND)
Great, the multi selection now works 🙂
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 352 Super User 2026 Season 2
M Bilal Khan 323
Mohsin Ali 226
