Hey guys,
We are going to be using Smartsheet to track initiatives of our stores. Each of our 120 stores will have 6-20 initiatives inputted into a single form, each as its own row. This form has about 30 columns of various data points, including the store number, and the store manager (contact list). The managers will log in using their credentials, and I know I can use the 'Current User' filter on the reports so they will view only their store's data.
My question is for the dashboard that I am building. Each initiative is worth points, so I'd want to be able to display that locations points on the dashboard. Each initiative will also have 'action items' (think basically a comment). I know I can accomplish this with a bunch of reports on a dashboard, but I'd like to make it look better and use metric widgets. I plan to have a helper sheet that will basically summarize the master sheet in the first paragraph. So instead of Store 01 having 6-20 lines, it would have just one, with the points being summarized (and a few other metrics). But I want the metric widget to pull the data point based on the currently logged in user Can a dashboard be filtered based on current user? Is there a workaround? I'm open to ideas.
For what it's worth, I'm building this as a WorkApp to more easily control everyone's access. We have store managers, regional mangers, district managers, and execs.
