-
Counting only CHECKED checkboxes in report summaries
I several reports I've created I need to get an accurate count of checked checkboxes within the summary section of the report, and currently, the summary is counting all checkboxes- whether they are checked or not. The image below shows that it's counting 4 checkboxes, but it should only be three since that's the total…
-
Smartsheet Report
Hi everyone, I'm experiencing an issue with a Smartsheet report. In one report, I grouped by project name and it displays correctly with collapsible sections. However, in a new report set up the same way, the project name disappears when grouped. Any advice would be appreciated. See screenshot belows I'm trying to group…
-
Can a form be combined with a sheet summary report?
I need to combine a sheet summary report of existing data with a form that can capture and record new, incoming data. I've done both separately, but need to know if this is possible in one sheet.
-
Help Article updates July 2025
Hello Community, We’ve published the following new content. New videos on these topics: Smartsheet Permissions and Sharing in Sharing permission levels and tasks How to create a Sheet Summary Report in Create a sheet summary report How to create a Row Report in Build a row report And these new best practices: DataTable…
-
How to calculate sumifs across multiple columns
Hello community! I am trying to build a summary worksheet to get an overview of all the meeting categories but my raw data has multiple data columns and the formula I am using comes up as an error Summary sheet Raw data I need to get a total sum from both "no. of meetings chaired by CPO" and "no. of meeting attended as a…
-
Metric Widget Not updating Summary Report Blueprint
✅ In my Blueprint, I have a project sheet with summary fields in the right-hand panel. ✅ Also in the Blueprint, I've built a Sheet Summary Report to pull these fields. ✅ In my Blueprint I've connected this to a dashboard. ✅ In Control Center I selected the new report to be included. ❌ But when I provision a project from…
-
Sheet Summary Report & PowerBI
Sheet Summary Report is such a great tool, it allows us to summarize data in a variety of ways without the need for helper rows/columns and allows us to create reports based off of this information. Unfortunately, I need one of those Summary Reports (not a Row Report) to pull into PowerBI and it can't do it, we continue to…
-
Cannot get donut chart to show legend
Hi, I am trying to get a donut chart to show the column labels as the legend but I cannot toggle that option on. I am using a Sheet Summary report and have tried a regular report with the data summarized but I cannot get anything to work. It is very simple but I do not know what to do since I cannot toggle the column names…
-
How do I create a pie chart from the data on my sheet? Assuming I need a formula?
I have a column with rows of dollar amounts called Grant Amount and a column with a drop down menu of three options called Scope of Work. My goal is to create a pie chart on my dashboard showing what percentage of the total amount of dollars from the Grant Amount column is going toward the options chosen in the Scope of…
-
Median and Mode options in Report Summary Options
We use Median for a lot of metrics as it helps to remove the outliers that can skew the data. Please add Median and Mode (if you are already updating it 😉) in the summary options for the reports.