hey michael - I'm using your new formula in the query and I'm still getting some very weird results. I have a name and a US state and then it returns someone with a completely different name and state
awesome thank you! I had also tried to make a flexible query where if there was a value in "U.S. State" it would also take it into account (which is why the query looked funky) - should I have written it differently?
