Sort Report by the Summary result
I am having a report grouped by region and summarized by numbers of process per region. it's only sorted alphabetical by region not possible to be sorted by summary numbers. Easy feature appreciate if it could be existed soon. Thanks team, Shorouk Helmy
Provide users with the ability to Print a Grouped Report
Per the 1.5 years of queries being made, I believe there is suitable interest from the Community that Smartsheet provides the basic functionality of being able to print a Grouped Report. The system currently reverts the Report to a basic Sheet when Print is selected. This is not suitable or acceptable. We've stopped…
Creating a chart from a multi-select dropdown among multiple sheets?
Hi there, I am running into a roadblock on creating a report and graph for the below scenario. We have a bunch of event sheets (about 10) that all have an 'assigned to' column that is a multi-select contact list and it varies between sometimes being assigned to just one person and sometimes to multiple. I am trying to…
Why is Dynamic View allowing me to build logic based off one set of dropdown values but not another?
I have a Dynamic View built from a report of multiple sheets. I am able to build logic in the DV based off a set of dropdown fields from one set of the sheets, as shown here: But when I try to do the same for another set of the sheets in the report, which has dropdown fields set up exactly the same way, there are no values…
Send Dashboard via email - manually and automated workflow
My idea is to create functionality to be able to send a dashboard snapshot via email from within Smartsheet, both manually and via an automated workflow. Ideally using an HTML format so any links in the dashboard are links in the email. Smartsheet Dashboards are fantastic and we use them heavily with our project teams and…
How to count cells when they have multiple values selected, and I'm only wanting a specific one?
Because we can't use wildcards on the program, I am at a loss to set up a report that summarizes my sheet. I'm trying to determine how many entries are the 'Status' outlined in each Primary Column row, where the 'Suggest Solution' is the text in each column header. The 'Status' can only be one value, but the 'Suggested…
Resource report gantt chart
Hello! I need to create a report to visualize resource utilization per project over time, similar to this: https://community.smartsheet.com/discussion/76598/how-do-you-track-parallel-projects-and-show-overlapping-resources Some important context: I do not have access to resource management or resource settings. All of my…
Can I pull columns in different Sheets in one report as long as Primary Column is the same?
Dear All: I tried the Community and I came up with nothing. Can I pull different columns in different Sheets in one report as long as the Primary Column is the same? The columns I need exist in different Sheets, not all Sheets have all the columns. However, the Primary Column is the same (“Interpreter Name” as Text/Number,…
Group Management Reporting Capability
I would like to be able to run a group report showing all the group names as well as those who are included within the groups.
Looking for Invoice tracker and/or Purchase Order tracking template
I inherited a sheet that I'm trying to redesign. We have multiple purchase orders (PO) with multiple invoices applied to each PO. Once an individual invoice is paid by accounting, we want to mark the row "complete" and move the row to an archive sheet. The PO needs to continue to reside on the original sheet so that…