Hello,
I am working with a household roster where I need to present 1. Married and 2. Female household members only after repeat group has ended. I can display list of household members from choices sheet fine. But when I try to filter using "sex" and "married" columns in the same sheet, no members are found (or even if i try to filter from just one column, nothing shows up). Only choice filter that works is: name <= ${mem_count} (display only until the member count).
My question is that can we choice filter dynamically on the user entered data as in the attachment?
Thank you for the assistance!
choices.xlsx (9.3 KB)