-
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…
-
Need to look for $99,000-$249,000 in Metrics Sheet. Can't find formula error
Need to look for $99,000-$249,000 in Metrics Sheet. Can't find formula error. =COUNTIFS({1. Case Queue Range 6},>"$99,000",<="$249,000")
-
PDF link in dashboard
It would be nice that a PDF can be dragged and posted to the dashboard. thanks!
-
Making a Smartsheet Dashboard Public
I am working on a request to create a dashboard that can be viewed without logging in. I created the dashboard and set the access control to "Available to anyone with the link". However, it still requires users to log in using their Smartsheet credentials to view it. Is it possible that the System Administrator has…
-
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…