-
How do I reference a Report Summary Field into a formula
I created a Sheet Summary Report for one of my Sheets. The Sheet Summary Report is grouping by JOB NAME and giving me MAX values for certain criteria I have a metric that is calculating a RATE and I do not want the MAX value of this rate in my sheet I only want the rate for the row in my sheet that has the 2 MAX values.…
-
COUNTIF or SUMIF Formula in Report Summaries
Currently the summary count function only supports basic formulas. It would be great to be able to have the ability to use a COUNTIF or SUMIF Formula in report summaries. Specifically to count only the checked boxes. This feature would be nice to roll up metric data quickly and avoid the need to create a separate metric…
-
Join ancestors EXCEPT the top level
Hi Smartsheeters, I would like to group my milestone report by workstream, so I added a "join ancestors" column. I also have a "count ancestors" column that can be used. My current report is a nightmare when sharing, as the top ancestor is the project name, and I can't control how massive (and not wrapped) the group header…
-
Help with Totaling Against Options in Multi Select Drop Down in a Report?
Hello! Here is my scenario - I have a set up like this in my sheet (this is of course dummy data just to give a visual of the sheet structure) - I am trying to create a report grouped by the "Assigned To" so that I can summarize the # Hours each person is assigned, and then have a chart widget from that on a dashboard. I…
-
Information page
I would like to have a sheet with all of my part numbers and the various information that pertains to each part number on it. I would then like to have some sort of sheet or report that has a dropdown for me to select the part number I am looking for, then it will populate all of the information for that part but in the…
-
Report - Recent Changes
Having a Report that you could run on a Sheet to show recent changes/cell history would be extremely helpful. This would allow for admins to drill down into recent changes and understand potential next steps to take. Also, having a Report that would show recent changes could be easily exported out and shared with…
-
Automated reports with attachments included
I have a few automated reports that go out every Monday. Is there a way to have this report (PDF or Excel) include the documents that are attached?
-
Open in New Window option for Summary Sheet-based Reports
For reports sourcing from Sheet Summary Data, you would like to be able to: right-click the Sheet Name link and "open in a new window" You could do this only if the the report is Row-Report sourced. Would like the same functionality for a Summary Sheet Report.
-
WEEKNUMBER function doesn't seem to be updating promptly?
Hi, I am using the following formula to populate a checkbox called "this week?" if a fitting is scheduled to take place this week: =IF(AND(YEAR(TODAY()) = YEAR([EXPECT FITTING DATE]@row), WEEKNUMBER(TODAY()) = WEEKNUMBER([EXPECT FITTING DATE]@row)), 1, 0) I'm using the checkbox to filter a report so the user can see what…
-
Grouping on Reports - Source Column is Dropdown List with Multiple Values allowed
I am creating a Report where once I apply my filtering, I need to be able to Group my results based on specific criteria. One of those criteria comes from a source column in a sheet where the column is a Dropdown List that is allowed to have multiple values selected. When I create the Report, the column with the…