-
Dashboard Filtering
In excel I can build dashboards with a data drop down list that contains a list of areas, at the top of the dashboard and loads of graphs linked to it ... I have 2nd sheet (Data Summary) that has cell A2 =(Dashboard dropdown) to provide data, with formulas that data changes if it matches cell A2. (It all comes from a 3rd…
-
Track Birthdays and Anniversaries coming up
I am trying to set up a dashboard to allow me to see upcoming Birthdays and Anniversaries, with them being sorted to earliest upcoming being at the top of the list. I tried, what I thought would have been to do a min collect, without luck. Then I thought maybe someone had a better idea as to how to make the happen.
-
How can I auto-scroll a dashboard
Hello All I have a Dashboard (or report if I have to) that I display on a central TV. The idea of this is that anyone passing the TV will look at it and see any active tickets or high profile stats. On the dashboard I have a couple of widgets and reports that go below the TV screen. I am looking for a way to auto-scroll…
-
Dashboard / Report - Labeling
I am building a dashboard based off a report that was created from Sheet Summaries of 4 different sheets. The widget below shows 2020, 2021, 2022, and 2023 YTD. I would like for either the blue dot or the base of the column to reflect the year associated with the values. I am certain it must be somewhere earlier in the…
-
How do I get a dashboard to auto scroll down, up, and continue to repeat?
I have several dashboards developed that are longer in length than the monitor they are getting displayed on. I would like to have these dashboards auto scroll up and down repeatedly so that all the content is displayed at some point during a predefined time interval. Has anyone found a browser extension or a way to get…
-
Dashboards: keep scroll position when navigating back
Currently, when navigating away from my dashboard (opening a report from the dashboard, for example), and then navigating back via the back button on the browser, the page loads at the top of the dashboard. It would be nice to be able to return to the previous scroll position on the page. This would be especially useful…
-
Sheet Summary Report Chart
I continue to get an error when I try to create a chart of a Sheet Summary Report. The error states "Selected Data can not be charted. Please select a new range". The data is pretty straightforward, its a list of 15 locations with a completeness between 0 and 100. I tried removing the percentage in my sheet summary…
-
Manpower Resource Loaded Schedule - SUMIFS Formula Help Needed
Hello, I have created a resource loaded schedule based on manpower in Smartsheets. I have a separate "Metrics Calculation" sheet where I am calculating the manpower per day and per department. However, I am having trouble performing the calculation using a SUMIFS function. Once this number is calculated, I want to roll…
-
Question about Dashboard/Sheet Permissions
Is there a way to set the view access to a certain domain? I only see a way to add individual users and groups, but would like a way for anyone who logins in with a specific domain to be able to view. In Smartsheet Dynamic View, there's an awesome permission setting that allows you to grant access to anyone who's email…
-
Can I link a Smartsheet dashboard to a sharepoint page? Please read the task below:
I am trying to link a Smartsheet dashboard to a Sharepoint page but this Smartsheet is edited twice a year and specific people need access to modify and then the rest of the business needs access to just view. How do I do this?