-
Report filter that includes "Today" correctly shows the rows on the report, but not when displayed v
I have a report that is set to show rows that have a "Date Published" column where the Date is equal to today or is in the past. For examples sake 12 rows in total. 4 rows have a past date, 4 rows have today's date, and 4 rows have no date or a date in the future. When viewing the report directly, the report is correctly…
-
Report for files not modified in last 45 days?
Is it possible to create a report to list all files (sheets) in a folder not modified in the last 45 days? To be clear: I know how to run a report that shows the ROWS modified within the sheets. I want to know when the SHEETS themselves were last modified. Background: Currently I have a folder with hundred of sheets. They…
-
Send alert/notifications including headrow and children rows in the attachment
Hi All, I want to send automated notifications to my employees containing their absence records. To do so I need to be able to send their Head row (containing their remaining balance of sick days/holidays/bereavement leave ...) and their children rows (1 row per period of absence) as attachment. So far I can only do this…
-
Alert(s) Updating a "Count" Sheet?
I have an end user I am trying to build a records sheet for and I can't figure out how to accomplish a change count cleanly. We have thousands of rows/records in a sheet with one of the fields/columns being a Status.They do a monthly review of how many records moved to different statuses in that month and I want to…
-
Reports and emails
From what I can see, reports do now allow formulas to be created within them (the formulas have to be in the sheets). I need to share lists of newly signed customers, recently created opportunities (pre-signed), recently cancelled customers, and customers we've decided not to take on along with the contract or potential…
-
Label Parent to Sub Tasks in Reports & Reminders
It would be helpful if Reports, Reminders and the current Outlook Beta displayed parent task descriptions when information is displayed for sub tasks. In our organization, many sub tasks could have similar descriptions in several phases of our projects. It would be beneifical to see the parent or outdented rows description…
-
"The source data for this chart has changed" - Charts with Zero Values
Hello. I have noticed that charts within a dashboard do not display and throw up a message: "The source data for this chart has changed" when they are pointed at sheets or reports where the value is zero / 0. This is problematic for me since I have created a dashboard for a template set of sheets and reports, and…
-
Reports Not Updating
I'm having issues where my reports are not updating. Is anyone else having the same problem?
-
Report Template?
Is there a way to save a report as a template? Like, so all the columns & criteria stay, but can just choose a new sheet for it to look at? My team & I all need to print our sheets each week, and our manager wants them to all look the same & be uniform, which I thought the easiest way to handle would be to set up a report…
-
Chart bug with labels
I have some metrics being calculated in a sheet, which I'm trying to pull into a column chart in a dashboard. Everything seems to work great until I deselect the option to use the column name as a label. I don't want the column name to appear in the chart, as it doesn't add any value, and is just confusing. But when…
