-
Grouping in Reports
Is it possible to group by a column in reports like Excel does? I need to create a report that groups projects by OKR/Goal and then by Project. So management wants to see how many projects are there per OKR.
-
Pivot App - How can filter a field
Hi there, I'm new using the Pivot App and I was wondering if there is a way to filter any of the fields in the pivot table. I have an excel pivot table that I'm trying to replicate in smartsheet from a master data that already is imported into my smartsheet. There is a column in the data master named "Current Status" with…
-
Printing a dashboard and one of the widgets is unaligned
In the online version, everything is perfect, when I print it to PDF, the milestone chevron lanes don't line up with the "assigned to"/"health"/"status" columns. How can I fix this?
-
Auto-Generated Date Report
It seems that you cannot run a report based on a filter condition such as "Not in the past X Days", if you are having the condition look at an auto-generated date. That seems odd, because within the grid, you can run a filter based on that same criteria - "Not in the past X Days" - and it works. Anyone know if you have to…
-
SUMIFS Formula for Rows Assigned to Multiple Contacts
Using the Sheet Summary function this formula worked: =SUMIFS({Budget Projected}, {Budget Account}, Variable@row, {Budget Assigned}, Employee#) when the lined was assigned to only one contact, but now that I have lines with multiple contacts assigned to them it will not recognize even the one employee's name anymore. I…
-
The new Report - missing " remove formatting" - search not working well
Hello I see there have been some pretty major changes to the Report interface, recently. 1) I used to be able to "remove formatting" so the source sheet formatting didn't carry over to the report. Where is that option, now? 2) It seems a report now has a max of 500 lines. I wanted to search my report for an item but it…
-
counting multiple select column
Hello, I have a project plan that I'm trying to report on. I have a column for health check and a column for assigned team. I want to see a total count of each status per team. That is the easy part and I figured that out by doing a =COUNTIFS({HealthCheck}, "Red", {Team}, OR(@cell = "FI", @cell = "FIT")) My issue is that…
-
Centrally managed column values? Multi-project rollup?
I'm a SmartSheet noob investigating whether it's possible to recreate in SmartSheet what we've done in Airtable. I'm pretty sure SmartSheet can do what we need, I'm just unclear on how to adapt the flexibility of Airtable to fit SmartSheet's more typical enterprise app structure. Questions: Does SmartSheet have a concept…
-
Conditional Formatting - Report
I have set up a conditional formatting rule that is certain values are out of range, the cell is highlighted red. I'm having trouble setting up a report that only displays the rows that are highlighted red. I've tried to set up a helper column but can't find a formula that refers to if the cell is a specific color. Any…
-
How can I create a Report that pulls data from both rows and the summary of multiple sheets?
I am looking to create a Report that consolidates data from multiple projects. I have a sheet for each project which includes Summary fields for each with items like Project Name and Description. I have a single row in each sheet for the data that changes month to month. e.g. Current spend to date. What I'm looking for is…