-
Merged: Create report off of a sheet you are working live in
This discussion has been merged.
-
Merged: Dynamic View - Grouping and Summery
This discussion has been merged.
-
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