-
how do i update the 'action tracker' status column from the action tracker updater sheet
I want to make a system where not everyone can see my action tracker sheet. What can I do to ensure that the status column can be updated to whosoever the action has been assigned to without them having to see the full sheet
-
COUNT multiple items in sheet summary fields
Hello I am trying to calculate a sheet summary field to show how many times a value appears in the Location column. I am using the Count if function but it is only returning a value when the "location" is presented on it's own. For eg: my formula is =COUNTIF([*Location]:[*Location], "VIC"). This formula responds with a…
-
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…
-
Summary Sheet Not Connecting to Correct Column
I have a summary sheet set up for my projects, which is connected to a metadata sheet I have. In the metadata sheet, I have column types for different types of data (contact, text/number, date, etc). In my summary sheet, the columns that should be looking at the text/number column for data are looking at the contact column…
-
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?
