Creating dynamic lists

Hobo

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

Hobo

Amber Eakin

Hi, @Hobo ! Is a Report an option?

https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

You could set up a Row Report using that sheet. Your two filters might be "TR1 Scope [is] Green" OR "TR2 Scope [is] Green." That would capture rows that have either TR1 or TR2 Scope column with that green check. That Report would be dynamic and would update as you add new rows or change the check in the column.