-
Can I use Summary fields in formula
I have created some sheet summary fields to count the number of records that meet a specific criteria e.g. Fire Doors - Pass is the summary field and the formula is =COUNTIFS([Last Month]:[Last Month], ="True", [Fire Doors]:[Fire Doors], ="Yes") I have done the same for several other fields too e.g. Fire Exit Routes -…
-
How can I remove decimal places for Summarized columns in a report?
Hi, The two circled columns are generated via the Summarize>Average function in this report. As suggested, I checked the source report and there are no decimal points. I have no way to format the Average function (i.e.: using Round, etc.). Any thoughts please?
-
Count Report
Hello, I have a sheet with 7 columns each indicating a different team or step in our process (UX, Content, Regulatory Review, Planning, Execution, Data, Testing). I also have around 300 rows of tasks that need to hit each team/step. All cells in the sheet begin at "Not Started" As they move through each team, the team…
-
Set Current Workspace as Default location when selecting "Source Sheets"
I think everyone will agree that they would like it if when selecting a report's "Source Sheets", that Smartsheet should use the current Workspace as the default location to find the data it should use in the report. Currently, it looks in the "Sheets" folder, which for some of us is miles away from where we want to be.…
-
Dashboard Reports Issue!
Hi All, I have unusual reporting issue which am unable to find solution in forum and am in need of some help. The issue: When I open dashboard one of the report just flick and then goes blank. Data / Filters testing: I've checked report, filters, all seems to be working fine and has correct data. Quick Fix: Refreshing…
-
Pulling the most recent entry into a report
Hi, I want to create a report that will have the most recent Project Health from a group of Project Update sheets. On each Project Update sheet, I created a help column to show the Max date = 1. I think this will work to get to the most recent update with the most recent Project Health, but I don't know how to construct…
-
How to actually USE the summary info from a report?
I have two reports both bringing in information from the same sheet. One is grouped first by country, then by month. The other is grouped just by month. For each of these groupings, I have it summarizing totals and maximums for each column. This is brilliant, this is exactly the information that I need. But now I need to…
-
Summary Field name changes do not reflect in the Summary Report
Whenever we edit summary fields in a particular sheet, the resultant report refuses to recognize the name change and just removes the data for that field. We then have to manually add the summary field back to the summary report. This should not happen. The summary field name changes should automatically reflect in the…
