-
How to create a dashboard to show increases
I need to track the cost impact of changes per community. We track changes using a CRF # - so for example if I have CRF # 2024-015 that effects two communities, I would like to be able to say "hey, CRF 2024-015 creates a cost change at San Tan 40's Electrical Contract by $589.50 or 13% AND it also creates a cost change at…
-
How to make Dashboard not auto-zoom.
Recently Smartsheet updated the width of dashboards which is neat, but since this update, all of my dashboards auto-zoom to fit the window they are open on. This makes them extremely zoomed in, which is not ideal for a lot of situations including that it disproportionately distorts things on the dashboard. I try to…
-
Can multiple users use the same sheet without causing changes for other users?
Sorry if my question is unclear. Here's what I'm getting at: I have an onboarding training checklist I made for all new hires. Each new hire has their own individual dashboard. Basically, I want to add the general onboarding checklist (which is a sheet) to each employee's dashboard. However, I want to know if there is a…
-
Cannot deselect "All Columns" in the Columns Included when creating a dashboard from a report
When I click on the x to remove All Columns to select which columns I want included in the chart it will not be removed. Also, when I try to add columns in addition to All COlumns being selected it provides an error- I am trying to build a chart widget that shows a "column" or bar chart breakdown of the count of items by…
-
Metric sheet filter for Dashboarding
Hello: I have a Metric Sheet that I use to feed data into a stacked column graph in the dashboard. The Metric Sheet has rows and rows of data each with a Totals column. For those rows with 0 in the Totals, I exclude them in the data for the stacked column graph. I've tried to apply a filter which removes the 0's so that…
-
Is there a way to build and cycle through dashboards for a number of similar projects?
Hi, I'm new to Smartsheet so maybe there's a simple way to do this, but I don't know how. We have about 50 projects that we need dashboards for. They will all be very similar, each containing some basic info about the project, team members, a few tasks, dates, and milestones. One project may have a few more tasks (and…
-
Calculation from Sheet with shuttled Data to combined data
I have a sheet that is refreshed every morning to add and update existing data from an in-house data warehouse. I am trying to create a sheet that pulls from the original sheet and can produce a graph in dashboard that tells me how long something has been in a current state, with many things being in that state for various…
-
Customizing the minimum and maximum values on the bar graph in the Dashboard
I am preparing several bar graphs in the Dashboard but the minimum and maximum values vary depending on the graphs. In my case, I want to set 0% as the minimum and 100% as the maximum value. I asked the technical support center but learned that there is no feature in the Dashboard. Please join me in requesting a useful…
-
Web Widget for Notes
I am looking for a 3rd party note-taking site to use as a web widget on a dashboard. I was previously using a Rich Text widget on the app and calling it the "Bulletin" but this is clunky. In order to add/ edit text on this bulletin, we have to "edit" the dashboard and click save. I want it to be edited easily. There has to…