-
Group Report By Month or Year
It would be fantastic if there was a built in way to group reports by month or year based on a date column. Something in the group settings when you choose group. If you select a date column you would have these options Oldest to Newest by Year Oldest to Newest by Month Oldest to Newest by Day Newest to Oldest by Year…
-
How do I convert dates into a time period (month) for reporting?
I am creating a savings dashboard and my primary sheet records the date the PO is issued. In my dashboard I want to display my savings by month or fiscal period. Is there a formula that will convert my rows with PO issued dates between date ranges into a fiscal period/month. Example: I want to convert row cells with any PO…
-
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.
-
Sheet path on report column.
Hi Team, The issue was on the report where multiple sheets had similar names with columns having different column types. Example --> Report with 200 sheets where 20 sheets have similar names and contains columns with the same name but different type so it will appear twice in the report column option but it would be very…
-
Easily identify all Reports impacted by a column change or removal
Need a way to proactively search (query a 'where used') on a column name to see all the Reports its used in.
-
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…
