-
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…
-
Merged: Group widgets in dashboards
This discussion has been merged.
-
Create groups of widgets on dashboards
It would be very helpful for us if we could create "groups" of widgets on dashboards, and allow actions to be taken on a group. I'm thinking this would be similar to how grouping works in the microsoft projects. First you select all the widgets you want in the group, then you select an option to group them. Our primary use…
-
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…
-
Dashboard Image Widget Data Source via cell from Sheet
For the Image widget type, expand ability of where to select the data source from to include option that matches that of the Metric widget - where you can choose a cell from a sheet. When using a workflow via Control Center, we intake Clients and capture their logos in a cell (as there is a nice option to insert image to a…
-
Icon / Image Library in Dashboards
It would be great to have a widget type within Smartsheet dashboards that provides a library of selectable icons / imagery to enhance the look and feel of dashboards!
-
Merged: Report over sheet that have a published with edit rights link
This discussion has been merged.
-
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).