-
Update to the Published versions of dashboards and reports
Instead of saying View Only, I would suggest an update to View of .......... This will allow that dashboard or report to be a friendly presentation instead of so rigid.
-
Combining rows with like names
We have a sheet set up with forms to allow for participants of a contest to #1 register for the contest, then #2 go to the second form to update their progress in the contest. Is there a way to combine rows when a someone submits the same name or email address, for easier tracking? Something that is automated to create…
-
Problem with alignment on dashboard
Hi I need help. I uploaded report to dashboard and the bars are off as you can see on the picture. What I'm doing wrong? On both: worksheet and report of the same I don't see this problem. All is aligned. Only when I upload all looks messed up. Please let me know how to fix it. Thanks
-
How do I create an chart to show ongoing activity?
I use the following to surface data to illustrate submissions over time over a set period of time (set start and end date). This uses a metric sheet with the dates in one column and a function adjacent to 'look' for the same dates in my source sheet. How do I create it to capture ongoing submissions? IE no end date? How do…
-
Multiple colors for a single series to preserve labels in a Dashboard chart
Hi! I've got a dashboard with a simple bar chart. I'd like to have each bar labeled with a text value but still preserve the ability to edit the colors of each "series". Current Dashboard: If I "Swap Rows & Columns": I want to have the coloring of the top chart with the labels like the bottom. Is there a way to do this?
-
Calendar App in Dashboard - removing header with links to calendar app list
When embedding a Calendar App in a dashboard (web content widget), it brings in the entire page view. Because of this, the user can follow the links in the header portion, such as help, or by clicking on the "calendar" text, they can go the the homepage listing all available calendars. They can also change views, filters,…
-
Create Chart Widget Using a Report (not a Sheet)
With the Dashboards, I am able to create charts from a sheet but not from a report (this requires using the report widget). I collect weekly "submission date" data from 40+ people. I have created a report that shows when the submission is due, when it is submitted, and the number of days (plus or minus) between the two. I…
-
Link sheet to rotating cell in feeder sheet
My team is trying to create a "wrap up" type sheet that pulls data from child sheets that are updated monthly from a form. The data in the child sheets that needs pulled are the most recent submissions from forms associated with the child sheets which means the cell will constantly change. Is there a way to link these…
-
Indenting Text for Dashboard Exports
Hey Smartsheet Community! I am posting this in response to the Engage Product Vision sessions that Ben Canning hosted, where there was some talk about someday exporting dashboard content other mediums such as PDF, Powerpoint, Google Slides, etc. In my company's change management journey we have been working hard to…
-
Totals From SUMIFS Displaying Incorrectly Within Sheets and Dashboards
Hi all, Wondering if anyone has any ideas or insight into data not displaying properly within graphs on a dashboard. The issue I experience is that data displays during the wrong 'time' or is assigned to the wrong criterion. Here's the issue: I have a data sheet that gets multiple form submissions per hour - sometimes…
