Hi - hoping someone has a suggestion. We are using Smartsheet Control Center and just started playing with Dynamic Reports. Our process updates the Dynamic Reports each time a new one is created; however, we want the ability to control what items are shown on the report based on a status that we can set. I understand we can archive the items through control center, but we are planning to do that annually. For our reports, we just want the ability to not show items that are complete in certain views.
My only thought is to add a column in the program plan that ties to the status that we want and populate the whole column with it and then add that as a filter to the dynamic report. I was hoping there was a better way to do that so wanted to ask the community. Appreciate any insights!