Creating dynamic lists

I want to create a summary/report based on another sheets data. I want to list the venues that are in scope for TR1 on a sheet and also list the venues that are in scope for TR2 on the same sheet and for this list to update as data is changes on the core data sheet. There could be up to 35 venues in each list and in some cases a venue may appear in both lists (in scope for both TR1 & TR2) i would typically sue and index and list row formula in excel and really keen to learn how to do this in Smartsheet. Below and example of the core data and the two expected output lists.

Thanks in anticipation



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!