-
Merged: Bring back ability to control indiv. bar colors on chart widgets
This discussion has been merged.
-
Ways to avoid 25000000 formula cell reference limit
We have a sheet that we use for time tracking for some of our projects. We have about a dozen people supporting projects and they may log their time multiple times a day. I have a SUMIFS formula that adds the duration for each client project. Formula: =SUMIFS(Duration:Duration, [Client ID]:[Client ID], [Client ID]@row ) I…
-
Summary sheet values don't update in dashboard without entering source sheet?
I have a sheet summary report on a dashboard and oftentimes the values will not update unless I go into the source sheet and manually save the updates. For example, the WEEK TIME OFF value often will not update week-to-week unless I go into that contact's sheet and save. I have tried adding a daily Chron automation…
-
Is there a way to update scaling on Smartsheet Dashboard graphs?
Hi, I'm having an issue where the graphs in the dashboard are auto scaling to the numbers in the table. I was hoping to get a scale of 100 for each of my graphs on my dashboard but there's seem to be no way to update this. Would anyone know how to update this?
-
Summary filed in sheet
Hi Team, I want to display the total amount below into dashboard And I guess I need to use below "sheet summary " , not sure how to get the total amount into the sheet summary Looking for ward to your reply, thanks in advance
-
Graphs on a Dashboard - Data selection and display
I am working on a dashboard that shows graphs from a constantly updating subset of data. Data is pushed from Snowflake into Smartsheet via a python script. Ive had trouble creating graphs on my dashboard due to the fact that I cannot select columns as a data set since my dataset grows and shrinks (Graphs only let me select…
-
Dynamic Dashboard Widget Size
Is it possible to have a Dashboard Widget expand or contract based on the number of rows in a report? I have a number of dashboards that are all the same, but the information varies greatly from report to report. I would like to consolidate white space as much as possible for the ones that only have a little information or…
-
Logarithmic scale for chart widgets
When using Dashboard Chart Widgets, the charts look great if the data is within similar parameters for each row/column. However, if you have one row that has outlier data (see picture), then all the other rows are hard to visually see what's going on. The solution would be to allow for charts to have a logarithmic scale to…
-
Include option in dashboard widget settings for open in new tab
I'd like there to be a new option in the dashboard widget settings to allow the choice of whether shortcut links are opened in a new tab or the same tab. This includes Smartsheet items (which currently don't open in new tab).
-
User Interface to collect smartsheet data
I have a smartsheet with data, I would like create a UI for other people where when they just type one of the specific data (such as name) and information about that row pops up without even opening the smartsheet. So it is easier and quicker to retrieve data.