Weekly report for incomplete cards with multiple variables

Question

Hi Team, good day. I am creating a weekly report whereby it captures incomplete cards (due date) from 3 card lists, with 4 variables (countries). If I don't specify which card list to use instead using all cards it works just fine but it will captures all other unnecessary card lists (about 10). Would very much appreciate any guidance here. Thank you.

Iain Dooley · Accepted Answer

@Yuri_Heartnet I have a hunch that the problem is that the "in list" conditions combine as "and" rather than "or", so what you might need to do is create a variable like "ANZ Action Item" and then create a second one called "ANZ In Progress" and so on, which will make the command much longer unfortunately -- maybe test that out with one of them first before you go to the trouble of doing it for all of them!