Relatively new smartsheet user so looking for some help. I want to create a portfolio of all projects that need my team support. Each team has their own project sheet and I do not need all the data in those sheets, just 4 columns for a summary sheet and then create some dashboard reports on it. 2 main blockers for me:
- All sheets do not have the same level of indent so when I filter for indent level in a report, data from the other sheets does not appear. Can we apply filters to specific sheet data i.e. From sheet 1, only data that has the filter checked should be pulled and the filter should not effect data from Sheet 2.
- Instead of report, if I create a master sheet to fetch just the 4 columns I need, is there a way to capture any additional rows that are added once the sheets are linked?
Is there another way to go about it? Thanks!