Clicking a Widget returns a a smartsheet that is filtered?
Here is the issue I am trying to solve:
I have a status report widget that is displayed for a number of users. When they click on it, I would like to link it to the source but only for their section (pre-filter it). Is that possible? I don't want to restrict access (use the advanced viewer radio button).
The scenario: 3 teams (Legal, construction, Resorts) use the same smartsheet and status reports. Legal wants to update their tasks. When they click on the widget, it returns the full unfiltered sheet. They then need to select the filter, etc.
What I want to happen: When they click on the status report, return only those tasks that are for legal (default filter for them only). They can turn it off, but just show their items only. So I would like to do a "user assigned to group" filter (?).
Thanks in advance....