Hi

I've created a microsoft form to enable employees to be able to do forklift inspections on smart device. The form asks specific question and can be answered with OK or Repair only.

The results table is then extracted with all the answers in the 'Inspections' tab, but I'd like that if any of the questions are answered 'Repair' a second tab called Repairs can display the 'Date of Inspection' and 'Questions Needing Repair' and the 'Comments', so that the manager who receives the report can quickly see what item of the forklift needs repaired without looking at the whole report on the Inspections tab.

I've attached spreadsheet with a couple of tests of the Microsoft form. In the attached sample, question Hydraulic Fluid Levels has been answered that it needs Repair and has a comment, and I've set up the Repairs tab and columns required there also.

Many Thanks

Darren

Attached Files

TELFORD - FORKLIFT TRUCK PRE-SHIFT INSPECTION CHECKLIST (1).xlsx (16.0 KB, 6 views)