-
Dynamic View - Grouping and Summery
Unlike reports, Dynamic View doesn't offer any Grouping or Formula Summery options. Please allow these features as Dynamic View is reports but BETTER permission levels etc. I am running into roadblocks when it comes to building solutions for scaleability but not having all the features in both.
-
Merged: formula in a report view
This discussion has been merged.
-
Add Column to Row Report that was not in original sheet
Hi! I have created a Row Report containing information from just one sheet, with one "What?" criteria. I have the desire to add another column to this report, that does not come from the original sheet, just for notes purposes. This column would have sensitive information in it that I do not want the other owners of the…
-
Auto refresh reports
Hello! I am using a report that consolidates data from 40 other sheets for Power BI reporting. The report doesn't refresh the data unless you click the refresh button. Other than using selenium, is there a native Smartsheet feature to refresh on scheduled intervals?
-
Merged: Reports Picking up Parent and Children tasks from master schedule sheet
This discussion has been merged.
-
Index/Match Formula - No Match to show Blank
I've been skimming the community here to try and find the IFERROR formula to add to my formula below so that if there is no match, a blank cell populates instead of #NO MATCH. The end goal is to populate a blank row so that users can put the right details into this cell from their reports. NO MATCH doesn't allow this.…
-
How to sort grouped data by year
Hello, I am trying to create a report sheet that would group data by their project end date. How do I set up the grouping so the Parent header is by year 2023,2022... etc. When I group currently by project end date, it creates individual headers for each date. thank you for input
-
Filtering a report by Calendar Month and sending report
Hello, I have a report that I would like filtering by calendar month showcasing data just for that month. I can only seem to filter the report by 'last 'x' amount of days'. Seeing as though months vary in days, the report it could show additional data not required. I had then created some helper columns on the underlying…
-
Stacked Column Perhaps?
On Hover (dashboard) I want to be able to see all the types of projects that each one has been assigned to through different colors. Kindly assist on how to go about this
-
Milestones not showing correctly in Report
I'm told "this worked before" I assume before means before the June 5, 2019 release of date formats. Situation: Project sheet has 0 duration task dependent on a 1 day task that ends at the end of the day (4:59pm according to the settings) Project sheet Gantt view shows task ending at 07/08/19 4:59 PM (Monday evening) as a…
