-
How do I pull in a table into a Dashboard?
I linked a form to a sheet that has the data that I want to pull into a dashboard. How do I create a table from that data into a Dashboard and be able to format it as needed.
-
Changing ownership makes Chart Widgets turn to Missing Source
As the Smartsheet Admin, I create most of the Sheets, Reports, and Dashboards for the Executive team. When we transfer ownership of all Sheets, Reports, and Dashboards to the Executives, their Dashboard Chart Widgets all state "Source Missing". Smartsheet's Help Desk provided this response: "... you may need to transfer…
-
How to create reports according to the Month
Hello Everyone, I hope all are doing great I wanted to generate a report which is getting data from multiple sheets and its primary column is Months so according to the months, I am creating the report/chart. Now, the problem is I want to create a graph for this which shows the current month and then the next 11 months.…
-
How do I make a form properly link to an image on a dashboard?
I have a created the form and linked it to several photos on the dashboard but when I click on the photo, instead of the poll view popping up - the backend summary sheet pops up. The goal is to have employees click on the item they would like and then fill out the survey that asks them their size.
-
Include Gantt Chart in Dashboard PDF
Is there a way to include a gantt chart when printing a dashboard to pdf? I currently use the web widget to add the gantt chart to our dashboards, but when I try to print to PDF, the gantt chart is blank.
-
Reports and Dashboards break if column is renamed in a Sheet
Reports and dashboards break if the columns in the source sheet are renamed :-( It will be great if @smartsheet does not depend on the column names from the sheet when used in reports as it will then not break the reports and hence the widgets in the dashboards using those reports as source.
-
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…
