-
Smartsheet Report in Card View Populating Data Incorrectly
My team is having an issue where a report suddenly stopped showing appropriate data based on the filters on the report. We are using the report in the Card View with the Assigned To contact as the grouping method, but people that are being filtered out are showing with 0 items and people that should be included are…
-
Reports - Percent Option with count, sum...
I would like to see an additional option for a secondary value-based column for percent of count, percent of sum on Reports. And the ability to pull that into the Dashboard in a chart.
-
Sheet Summary Fields in Notifications
Is there a way to add sheet summary fields in a notification? It is possible to add cells by using {{Field}} but this doesn't work for the summary fields. Any inputs are much appreciated.
-
Report Filters
Hi, I am trying to create a task list report for our team members using data from multiple client sheets. Ideally, each person would have their own report that shows them what they need to complete related to each client. I would like the report to show only their tasks (plus parent rows) that are either past the deadline…
-
Text size on dashboard
I created a dashboard with the intention saving it to a PDF. However, the font in the body of the reports that I included on the dashboard is very small (I think 10 pt). Is there a way to change the font for the body of the report on the dashboard? I am able to change the font when I go to the report, but that does not…
-
Sorting in Report
I am trying to create a dashboard widget to show Risks in order (High, Medium, Low) but in the report, it does not let me sort it that order. I tried to create a helper column in the underlying sheet using 1 for High, 2 for Medium, and 3 for Low however even when I group, sort, or summary count off these, I am unable to…
-
Required advice on creating a view on Overdue tasks
Hi, Smartsheet champions. Does anybody have ideas on creating a view like below (or similar) on Overdue tasks? Perhaps creating a column in tasks sheet with formulas to calculate the Days Ago number and pulling a report will work?
-
Unable to Access Large Sheets But Data Still Accessible
I've been having an issue the last couple of weeks with two very large sheets. One is automatically updated via Data Shuttle and the other has rows pushed to it weekly. I can't open them directly but I know they are still functional because I can still move rows to them, other sheets can access the data via formulas, and I…
-
How to access all columns in a Report when creating a Dashboard Chart?
Hello! I have a report that is summarizing project costs, sorted first by the line-item code in the budget and then by Quarter of Completion afterword. I am hoping to represent this data graphically with a dashboard chart. The goal is to have a Bar Graph that shows the cost in each quarter, clustered by the budget item.…
-
What is the maximum row count for a report (I know there is up to 2,500 rows per page)