-
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.
-
Set Current Workspace as Default location when selecting "Source Sheets"
I think everyone will agree that they would like it if when selecting a report's "Source Sheets", that Smartsheet should use the current Workspace as the default location to find the data it should use in the report. Currently, it looks in the "Sheets" folder, which for some of us is miles away from where we want to be.…
-
Formula based of portfolio report
Hi, I would like to do a simple count and countif based of my portfolio report. But when I start the formula and want to link to the report, it is not available for selection. I am the admin/owner of the report. Is it just not possible to use a portfolio file for formulas?
-
How to Automate workflow to create a summary report to diff between two excel sheets on weekly basis
Using SmartSheet, I want to be able to import excel sheet from sharepoint on weekly bases lets say "week 09" excel sheet name is [TC Roadmap 25ww09 VTS] Then I need to add to end additional +5 columns, these column includes formula(s) which I use to massage data coming from original data to create reports After a week ,…
-
Column descriptions
Hello, Why i do not see Column Descriptions in the Report? thanks!