-
Dashboard Metric Widget Not Updating with Current Backend Sheet Value
Hi all, This is from a sheet that uses a formula to count down / display the number of days til end of Quarter. What is happening: Displays 37 when the backend sheet actually says 34. The dashboard does not update until I click to open the backend sheet then the connection seems to go through to update the…
-
Chart Widget Formatting Issues
Hi, I have an issue whereby the values of my charts are cut off at the end - see attached. How can I format these so that all values are on the chart?
-
Is there a way to make reports on a dashboard interactive?
I would love to be able to check off items in a report directly in my dashboards, without being redirected to the source report or sheet. I cannot see how to do this - is it possible? Thanks Hannah
-
Dashboard sharing options
Hi, I was wondering when the dashboard sharing option changed. We used to share people as editor and now we can only share as admin or viewer! Thank you
-
Counting Entries Satisfying a Condition and Within a Certain Month/Year
Hello Everyone! I am trying to create a formula that counts the number of times a condition is satisfied for each month/year. My sheet has a column "Parameter" that either has the value "OFF" or "ON". I would like to create a formula that counts the number of times "OFF" occurs per month. However, the dates in my data…
-
Can I automate what lane a card in the dashboard is in based on filling out another linked sheet?
Can I update a dashboard to change status based on another linked sheet? E.g. once tasks 1, 2, and 3 are done I would like the card to automatically move to the next lane/status.
-
Add Dynamic View (without formatting) as a web content widget on dashboard
We create a lot of dynamic views for our internal teams and need to present them on executive dashboards for leadership review at the end of the project/audit. Having a bunch of different formatting on these views doesn't appear very nicely on the dashboard and even if we turn them off in the DV, they still show up as soon…
-
Chart widget not graphing dates correctly
I am trying to graph the costs spent on projects per month in th dashboard using the chart widget. The problem is when the project goes into the next year instead of setting the first months spend ahead the last month in the last years spend it moves it to be next to the same month in the previous year as seen in the…
-
Embed a Resource Management Report in Smartsheet Dashboard?
Trying to embed a Resource Management Analytics report into a Smartsheet Dashboard, but it's not working. Not sure how to get the "embed" code. Is this possible? Found this link, and although it doesn't say you can embed RM reports, at the right side it does say to get the URL: "Analytics page: rm.smartsheet.com/analytics"…
-
How to visualize program status
I have recently come on to a large program with many different projects all at various stages. My immediate goal is to consolidate this information and try to visualize it on a dashboard so that we can start to understand where each project is. A general overview of our project life cycle: Ideation (V0) —> R&D Planning…