-
Sum based on two columns, words and sum numbers
Hello, I am trying to figure out a formula that will SUMIFS my first range says "Perfect Match 111" and my second range has a number in it. Example if "Perfect Match 111" is in my first range 3 times then I want it to sum the number that is in my second range. So below I would want 6 to come back to my sheet. I have tried…
-
Request for Dashboard Chart Widget to Support Multiple Groups in Report
Currently, chart widgets on dashboards that are sourced by a report with multiple groupings only display data for the first grouping. This request is to optimize the chart widget to support data from multiple groupings in a report. For example, in a chart widget, display how many hours are planned for each team member,…
-
How to best track Outstanding Update Requests
We are a construction company and I am trying to build automations and a dashboard for tracking "Outstanding Update Requests" - Each of our Line-Item tasks require us to acquire information from 3rd parties. This information takes standard forms (Start Date, End Date, Comments, Attachments, etc), but the specific fields…
-
Conditional formatting for Reports
The ability to apply conditional formatting rules from within a report would be huge. Having to modify the Source sheet for a specific report doesn't seem to be very efficient.
-
Public sector - public records requests
Hello, we are a public sector organization, and any information entered into Smartsheet is subject to open records requests. Is there anyone else who has to search and provide data in Smartsheet to the public? If so, how do you provide that information? If it is a project plan, do you export to a PDF? Does that include the…
-
Allow reports to be scrollable on mobile devices
We publish a report to the tablets in all our buses that tell the drivers when there is an off-route pickup. Sometimes there are too many requests to fit on the first page of the report as it is displayed on the tablets and there is not a way to scroll down. This is not an issue on the desktop version. Can you make reports…
-
"Save as new" with more than 100 items
Is there any way around the 100 item limit when using" save-as-new". I built a large reporting and dashboard structure with hundreds of individual reports and aggregate dashboards. The reporting structure is for a state agency that contracts with many partners, so lots of reports and dashboards for each individual partner.…
-
Fiscal Reports
There are quite a few workarounds that have to be designed for Fiscal reporting in underlying assets. New idea is to have a way to have capability built into reporting for integrated options for both calendar dates as well as fiscal dates. Or to toggle between calendar and fiscal month. Week, Month, Quarter, and Year.
-
Report will not average negative values correctly for baseline variance.
Hello, I have a project sheet that calculates Variance from the schedule baseline. I am trying to create a report from this sheet that shows the average Variance for each supplier (from the Assigned to column). As you can see in the image, some of the variance values are negative, and some are positive. When I try to use…