-
Filter by Cell Color in Reports
When creating a report from multiple smartsheets, I want the functionality to be able to filter rows by color. This way, if I need the sum of certain rows/parent rows, while excluding others, I can easily do so without duplicating numbers.
-
Need help with a master report to create conditions within a calendar.
I am trying to create a master report where it shows vacation days for the team as well as due dates for the projects they are working on. With that being said, I would like for the start/end date to show on the calendar for vacation, but ONLY the end date to show for the projects since they are usually pretty long…
-
Pull out some data from report into a metric sheet
Hello, I have created a report that shows the manager's name with the count of missing ratings. I would like to pull out this information and put it into a metric sheet that would have the manager name in one column and against the name a column with the number of missing ratings. I am very new to Smartsheet and despite…
-
Update Column Names in Report Filters
I searched for this feature request in the Community but didn't find another post to upvote. It's great that reports mostly no longer break when a column name is changed, but if you change the name of a column used in a report filter, that does still break. You won't even realize it unless you notice an issue with the rows…
-
Merged: Add Calculated Column Functionality to Reports
This discussion has been merged.
-
Column Formula + Reports
Curious why a column that has a formula applied cant be changed when it's pulled into a report - from the report? Also wondering if there is a way that is quick to remove the formula from an entire column? I've switched one back to 'cell formula' to allow for edit from the report but, would like to avoid running down 600…
-
How to compare columns from multiple sheets with the same criteria using reports without a data gap
Hello, I have a consistent budget with the same account codes/names across multiple businesses and was trying to use reports to compare a specific column that is in each of those budget sheets. My original problem was that reports stacked the data in a single column but I needed the information to be side by side to be…
-
Retention Rate and Tenure Rate for employees for current year
I am needing help. I want to create a dashboard to see the current years tenure rate and retention rate by tracking month to month. I have a column for retention status (active vs terminated rate), active status count. Termination month, termination year, termination date, hire date. I have a formula for total employee…
-
Summarizing a column in a report is only giving me a sum of half the data
I built a report from two separate sheets using a row report. I intend to add onto this weekly. When I try to total the sum of one column it's only giving me the value of half of the data. It's only giving me the total amount from the bottom half. Is there another way to group this information? In both sheets I've named…
-
Column Parity Override in Reports
I would really appreciate a feature in the advanced setup for a report where you could tell the system that two columns with different names should be displayed together under a new name, kind of like how the Primary column functions. I occasionally find that I have two pieces of like information that should be displayed…