-
Multiple, comma separated values in one cell
Hi I'd like to create a report which returns all rows that have a certain value in column 'Donors' - i.e. we have activities that are funded by one or multiple donors, and I'd like to return all activities that are funded by Donor X. Conference one - donor x, y, z Conference two - donor y, z Three - donor x And the report…
-
COUNTIFS returning #INCORRECT ARGUMENT SET
Hi all - I cannot figure out what's going wrong here. I'm trying to count rows in another sheet ("Sheet A") where both the following are true: * Done = 0 * IsChild = 0 My formula is: * =COUNTIFS({Sheet A Range 2}, 0, {Sheet A Range 4}, 0) Now this works perfectly! So in a cell right below that one, I then try to count rows…
-
Enhancement Request: Formatting for Reports
There are numerous posts on improving formatting on Reports. Here is a specific use case: I have a sheet with multiple date columns and tasks. On one report, I am showing (either Gantt or Calendar) view of the tasks color coded by task. In a second report, I would like to show the dates (either Gantt or Calendar) view with…
-
Creating a Task Tracker for Multiple Leaders
I manage a large group of leaders and locations who all are completing similar tasks throughout the month and I am looking to track progress without going back and forth via email. I have created a task list for each location as the parent and each specific task as sub-tasks and then assigned them to each leader. When I…
-
Reports Published To A Site
I have a report that I have published to a dashboard/site. I need the users to be able click on the Widget in the site to open the report, mainly so they can view comments on the rows in the reports. I need them to be able to do this without them being granted access to the source sheets. Any assistance or direction on…
-
Emailing Blank Reports
Is there really no way to stop the system from auto-emailing a report if the report is blank? Does anyone else have this issue?
-
Reports - pdf or Excel ?
I send out weekly reports of our products to our customers with their expected delivery dates (which can change frequently). If an email address needs to change I am unable to see the original format of their report, so have to guess their preferred format - pdf or Excel. Short of sending copies of each report to myself…
-
Gantt Chart Revenue Forecasting
I've built a sheet with all of our active projects and am wanting to predict revenue. I am wondering if I can add expected revenue to milestones in a gantt chart and have it report monthly expected income as a report or on the chart itself somehow? I really just need a monthly total of expected revenue as I pile more and…
-
Report Sheet Scope Limit
I am receiving a notice that our reports have 302 sheets in scope and that it is recommended that the scope be reduced to 250 for better performance. Does anyone have insight into what performance issues having too many sheets create, and any workarounds? Is there the ability to improve whatever is causing that limit? We…
-
Upcoming Birthday Report
I would like to include a Report Widget that shows upcoming birthdays, but it doesn't seem possible to only pull data according to month and date (whenever I use the date column, it automatically adds the year -- 2018, in this case). Is there anyway that I can pull data for upcoming birthdays w/o relying on the year they…