I set up filters for each task owner in my smartsheet, with specific criteria, (% Complete less than 100, start date is not in the future, etc.) to send update requests with only the tasks they need to report on at the time. Is there a way to create a dynamic automatic update request based on these filters? I currently have requests going out weekly based on what the filters returned at the time of creation, but the rows in the request do not change. The update request is tied to the row number, not the filter results. Is there a trick to accomplish dynamic, automatic, filter-based update requests?
