Hi all, I am currently having a problem to establish the XLSform. Below is the description of problem. ---------------------------------------------------------------------- If there is a number of weeds with few locations as where they exist, how to take out the weeds I need by selecting multiple locations with ignoring the other locations in one row/command? Take 2 scenarios for example. Scenario1 - I need to have all weeds located in both Darwin and Katherine, having weeds 2, 6 and 7 selected with ignoring the other locations. Scenario2 - I need to have all weeds located in Alice Springs, having weeds 5 and 7 selected with ignoring the other locations. Above two results should base on the same row/command in "choice_filter" column. With these limitations, how to input into "choice_filter" column of "survey" tab to make above 2 scenarios happen by using "and" or "or" or other possible functions? ---------------------------------------------------------------------------------------- If anyone knows about solution for the question, please let me know. Thanks in advance Howard
... View more