I have a need to create a SharePoint questionnaire for building inspections.
These inspections are to be performed weekly by different departments
Each area to be inspected will have a reply of: satisfactory, unsatisfactory, safety hazard, or well maintained. The questions will be grouped according to departments.
Once all answers are submitted, I need to be able to total the number or satisfactory responses, US responses, etc.
I've tried using the out of the box survey with a lookup to the answer choices, but the export to excel does not give me a good way to total the responses.
Example: Kitchen Questions Q: Floor Answer choices: S, US, SH, WM Q: Refrigerator Answer choices: S, US, SH, WM
Warehouse Questions: Q: Forklift Answer choices: S, US, SH, WM Q: Storage Shelves Answer choices: S, US, SH, WM
Once these questions are answered, I will need to total the number of each answer choice according to the departments.
I've also tried using InfoPath with yes/no checkboxes by each answer choice. Needless to say, this created way too many fields to keep track of.
Any and all ideas are appreciated!