-
Create time card from project schedules
Is there a template out ther somewhere to take all projects shared to an individual and create a weekly report (timecard) showing the number of hours that indiviual is scheduled to work on each project? It seems like most of this is available in Resource manager but I'd like to have it report hours versus % allocation.
-
Calculations in a report
I'm trying to create a report where i only see records with End Date = this week. (so not 'the coming 7 days' or something, only this week#) I have column 'Week# that shows the week# of the field 'End Date' in my sheet =ROUND((([End Date]1 - DATE(2015, 1, 1)) / 7) + 0.49, 0) in my report I defined in the 'What' part:…
-
Counting in summary reports
Hi All, I'm interested if anyone has found a good way to use sheets or reports to count fields meeting a given criteria from another sheet. In my particular case I have one sheet that lists (and links to) project sheets. I would like to have another sheet/report that counts how many projects are green/have a particular…
-
More A-Z Sort options.
Is it possible to add more sorting options. right now we only have three drop down bars, I need four. How can I add more?
-
Using or not using hierarchies
For sales I have been advised not to use heirarchies to group things by areas like likelihood, potential size, stage of progress, etc, because once they're a few pages long it's a bit unweildy. I was advised to use no hierarchies for a sales pipeline and instead rely on Reports for all of that. But I see that with the…
-
Net Promoter Score
I have a survey web form. One of the questions is "likelihood to recommend" with a dropdown list of 0 - 10. I'm trying to build a report from this web form that will automatically calculate the net promoter score (% promoters (9&10s) - % detractors (0-6s)). I know how to build the formulas to calculate these, but I don't…
-
Is there a way to apply conditional formatting or grouping to reports?
Looking for a way to utilize the reports functionality. It would really help to have conditional formatting capability as well as grouping functions.
-
Permission to view a report in one Workspace that points to a sheet in another Workspace
I would like to create a report in a Workspace that is view only to a group in that Workspace, and have this report pulled from a sheet in another Workspace that this Group would not be allowed to view. This does not seem to work, as the Group permissions don't allow this report to be run since this group is not allowed to…
-
planned versus actual
Is there a way to track what hours are actually spent on a task in relation to the hours that were planned?
-
Count Info Across Multiple Sheets
Howdy! I have five sheets that my regional teams update about their current status of projects. I am wanting to create a report that shows a breakdown by count of each region. For example, if the West Region has 10 active projects and the Central Region has 5, I would like a report that would pull data from both sheets and…
