-
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.…
-
How can I summarize 26 sheets and then generate a document
This is a complex one that has been rattling around my brain for a while now. We have 26 sheets, each has a form tied to it that allows folks to enter information based on review/compliance questions. Example: AB 1.1.1 Did you observe them following rules? - If yes they receive a % score if No they receive a 0 and in the…
-
Sheet Summary data not updating on Dashboard
My sheet summary data is intermittently not updating or very delayed in updating on my Dashboard. What makes it even weirder is that part of the sheet summary information from the same sheet will update, but another part of it will not. How can I fix this? Is there a known issue with this?
-
Multi Select Drop Down on Sheet Summary
Currently in Sheet Summary, there is no option for a Multi-Select Drop down field. The request is to incorporate multi select to the drop down field option within Sheet Summary.
-
Cell Link/Reference - COUNT Question
Good Afternoon all, hoping for some assistance with this formula I am putting together. For my Number of Dealers Column on Sheet 1, I am trying to get a formula to count the number of Dealer ID's that fall under a certain Market. For Sheet 1 the formula will be looking up cells from Sheet 2. The formula needs to match the…
-
Emailing Summary Reports With Summary Details
Currently when an automated email is setup for a report, the attachment in the email will not include any summary data you have setup in the report. It would be fantastic to be able to have that included.
-
How to email a report with summary detail included?
I have a report that has summary data built into it using the summary functions. When I create automated emails the summary information is not included in the emailed attachment. How can that summary detail be added to the attachment?
-
Sheet Summary Formula - (status type) due in next 7 days
I have a manually altered date column [Next BHL Follow Up Date] and a status column with a few options such as "Give Reminder to Attend Appointment" How do I get a sheet summary that tells me the number of Give Reminder to Attend Appointment s are dated for the next 7 days? Thanks, Alix
-
How can I include comments in a portfolio view?
I'm hoping to use Sheet Summaries on project plans to roll all project information into a portfolio report, but one thing that I need is a way to have a 'status update'. We use comments and the conversation tab heavily in project plans, so I can pull a 'latest comment' column, but I want to pull comments made for the…
-
Merged: Sheet Summary Field - Add Format Painter Tool
This discussion has been merged.