-
How can a contact field by aggregated to show a count?
I have a list of projects and each project has an individual as a contact. An individual could be listed for multiple projects. I'd like to chart to reflect how many projects each individual is responsible for. The trouble I'm encountering is that the report doesn't allow me to summarize on the contact list field and the…
-
Project Tracking & Rollup Dashboard Question
Help! I'm new to Smartsheet so this may be a dumb question. On the dashboard template "Project Tracking & Rollup" why doesn't "Percent Complete" (16%) under Project information) match the "Complete" status (1%) on "Tasks by Status" widget? Confusing ... Thanks!!!!!!
-
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…
