-
Report Filter by Current Job
Hi All: I have been working furiously for the last few months completely redesigning how we use Smartsheet since we purchased Control Centre. The automation is great but I have come across a load of roadblocks trying to manipulate Smartsheet and Control Centre to do what I need it to do. With that being said, I am looking…
-
Enable PDF print of Dashboard and Export to Excel of Reports from Power Automate
It appears that the automatic (scheduled) backup feature from Smartsheet does not include either the Reports or the Dashboards. These are left to the user to be manually "Save as" or "Print as PDF" every single time one wishes to have a backup. This is very inconvenient, I have about a dozen dashboards that I would like to…
-
Am I unable to create stacked bar charts from reports?
Hi, I'm currently trying to build a personal dashboard so that each person in our team (~75 users) is able to see their own individual metrics. One of the things I'm trying to build is a view where we can see their time spent on individual tasks as a percentage for each month over the last 12. Naturally with this being a…
-
Report Filters Not Responsive
I've created a helper column in my sheet for parent/child relationships, which assigns it a number based on this formula: =COUNT(ANCESTORS([SOW Item or Task]@row)) + IF(COUNT(CHILDREN([SOW Item or Task]@row)) > 0, "+", "") In my report, I've created a filter to allow for all numbers except 1+: However, the report is not…
-
Rolling up counts from several sheets to a dashboard
I have 6 projects. Each has a risk register on a separate sheet Each risk has one of 5 possible statuses each of which has a color, (Blue, red, green…). Each risk also has a Probability/Impact score, grouped by 5s, 1-25 I have created 10 sheet summary fields on each sheet to count these. I have created a sheet summary…
-
Pie Chart from Two Sheets
Hello I have two sheets that are in effect the same - same column headers etc, but different source data feeding in. I have a sheet summary on each. For example, if column 1 has a yes/no option, I do the following on each sheet: =COUNTIF([1. Internal Process]:[1. Internal Process], "yes") I now need to be able to combine…
-
Ability to add Sheet Summary Reports to Dynamic Scoping on Control Center
This functionality is available for "Row" reports, but "Summary" reports really should be included. Many clients use sheet summary to keep grids clean and lean; but, if we can't leverage dynamic scoping for those type of reports, it weakens the case for Control Center. It's either we bulk sheets up with columns to fully…
-
Grouping and summarizing in reports
Is there a way to have two separate groups in reports? Not one "then" another, but two separate ones. I have columns with checkboxes, and I want to group them separately so we can see which rows have "Answered?" checked and which have "Follow-up?" checked, but we don't want it to group in this way because we will have some…
-
Sharing reports with free users
Hi - I have created a report and shared it with an external free user, however, he is unable to see anything on the report. I also tried publishing the report and placing it as a widget in a dashboard with no luck. Is there anyone that has done this and can let me know how to provide them the info? I also wanted them to be…
-
Group Multi-Select Dropdown and Multi-Select Contact Columns within Reports
It would be great if we had the option to group line items in a report by options selected in a dropdown column. Ex. If you are viewing projects within a global campaign and have "country" as a column with the fixed values for all the available countries. It would be nice to be able to run a report where you could group…
