Spreadsheet: 675375d1588261396-how-to-not-input-cell-information-when-an-adjacent-cells-hasnt-been-completed-columns-running-down-sheet
Sheet: Sheet1

Driver name | Risk Rating | Total Risk Score
[NAME] |  | 10
[NAME] |  | 20
[NAME] |  | 8
[NAME] |  | 15
Mick |  | 26
[NAME] |  | 7
[NAME] |  | 0
Jeremy |  | 17
[NAME] |  | 10
[NAME] |  | 13
[NAME] |  | 11
billy |  | 12
 |  | 4
 |  | 4 | Based on the full sheet the number 4 comes from an employee not doing something but my staff wont see the total risk score column
 |  | 4
Need to |  | 4
stop these running |  | 4
down the page but still work |  | 4
if I put a name into col A |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4
 |  | 4