Reports

How to Calculate Percent Complete in Sheet Summary
My sheet is used as a task checklist for projects. It currently has a 'Status' column for each Child task with 4 dropdowns (Not Started, In Process, Complete, N/A). I am trying to create a percentage in Sheet Summary that calculates the number of fields that are marked 'Complete' in the selected cells. Pulled this formula…
Merged: Merging rows between different sheets in a report
This discussion has been merged.
Format report as a form; export to Word
I would like to be able to use SS as a repository for data that can then be output through a form and imported into a Word document as formatted text, using Word style assignments.
Merged: Sort Rows by Count (in Reports)
This discussion has been merged.
Is it possible to conditionally format the colors on a bar chart?
I am tracking service level across clients. In the reports I get the formulas and conditional format to work but I can't get it to translate into my charts. Is it possible?
Report Filter Conundrum
I want to filter out these parameters - A project has 'New Store Unchecked' and 'Survey Scope Unchecked' The problem is that when a project has New Store Checked it will always have Survey Scope unchecked so I cant filter by 'Survey Scope Checked' as 'or' in the filter because I need to see those New Stores. Is there…
Validation on Dates and or other data
Hello, We are trying to create a vehicle reservation form, we currently have 3 vehicles. Objective: A user submits a form to reserve one of the three vehicles. They select a date range. Click on all day or duration if it's half day. The administrator of the vehicles will then get the request and determine what's available.…
Color of Progress Bar in Report in Gantt View
I am running a report and when I do, the color of the progress bar in gantt view changes colors. One the individual sheet the bars and green, but they change to blue, orange, red, yellow, etc in the report. I cannot find any correlation to what colors they are changed to. Has anyone else seen/experienced this?
Need report and forms to track client status
Working on a project with about 680 customers managed by 8 customer success managers. I need to track each customer's status throughout the project (will run through the year) with about 5 milestones. I'd also like to have a form so the CSMs can easily update the client's status after speaking with them, and a dashboard or…
How can i view the Utilization report in terms of Actual and Available days instead of hours?

Reports

Discussion List