Search the Community

I have a marionette network that begins with a UI Boolean into an "If Switch," but the entire network runs regardless of if a value is sent down a certain path or not. Is there a way I can prevent part of the network from running if the "if Switch" doesn't send data down the line? Below is a screenshot of the current node structure:

I have a worksheet of plant counts by area - see attached. Each block of text in the worksheet is a plant label for one polygon. What I want to do is sum the totals for each species across the different label areas. I want to do the summing in another worksheet so I can send a nice tidy list to my plant supplier and planter. I have highlighted a couple of plant names to illustrate this, e.g. I want to get the total number of sophora microphylla across all labels. I imagine I need an if statement (or similar) in my other worksheet that whenever it comes across Sophora microphylla it goes across 2 columns, gets that number and adds it to a running total - I wouldn't have a clue how to do this but no doubt someone here else has with an inventory or related problem. In the final case there may be ~ 100 labels. I'm using this method as it works best for my sites and far faster and less complicated than the plant tags landscape areas, also this way I can skim backwards and forwards through the different areas in the table. I don't really want to use vectorworks’ database, but I trust the worksheet system.