-
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…
-
Pre-Built Chart Color Schemes
Our team would find it very useful to create pre-built themes for charts without affecting the rest of the dashboard. As an example, we use a color scheme of red/blue/green/gray for status updates but would love the ability to save a palette of different shades of blue to display other metrics without confusing end users…
-
Links in dashboard freezing
Over the last week or 2, I'm finding that dashboard links 'freeze', ie. stop working after some time, ie. maybe 20 minutes or so after dashboard opened. This is happening with dashboards via the desktop app, and with Chrome and Edge browsers. Once it's 'frozen', as I move the cursor around the page, the links are 'dead',…
-
Question on graphing data on a dashboard while using a smartsheet form
Hello, I am trying to graph data for production as close to real time as possible. We run a test and then use a form to populate a smartsheet. I have a dashboard pulling from that smartsheet to graph the data. I want the graph to populate based on new data entries, however the graph will only populate based on the data I…
-
Dynamic Dashboards
Hello - I have a source data sheet with the below columns: leader category level access list Access list is used for row level security and ties directly to leader. From this sheet I have 3 aggregated reports: 1 for leader, 1 for category, and 1 for level. The reports are also filtered by access list has any of Current…
-
Collecting time range in form
I'm creating a form to collect the days and times that employees will be out of the office so that I can get the info onto a dashboard for the team to refer back to. Since Smartsheet doesn't have time fields for forms the best workaround I could find was using dropdown fields with half hour time segments and have one field…