-
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…
-
"Select All" Checkbox Option on Report
It would be far more efficient to have a "Select All" / "Deselect All" checkbox when going to choose which columns to display on a report. This is standard in Excel