Spreadsheet: 715218d1611607096-can-not-get-formula-to-report-a-change-in-cell-value-test-weather-roads-01252021
Sheet: VehicleCountingData

 | Paste your Counting Data into this section. Then proceed to the Admin worksheet to enter the Job details. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] testing result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time | Time | UMI
 | Time | Counter ID | Type | Direction From | Direction To | Count | Weather | Road | DateTime |  |  |  | UMI |  |  |  |  |  |  | 07:00:00 | 07:15:00 | [NAME]
 |  | new_admin | A | East | Right | 10 | Party Cloudy | Bare | 1900-01-01 10:25:00 |  |  |  |  |  |  |  |  |  |  | Number of UMI from 7:00 - 7:15 am
 |  | new_admin | A | East | Through | 10 | Party Cloudy | Bare
 |  | new_admin | A | East | Left | 10 | Party Cloudy | Bare
 |  | new_admin | A | South | Left | 10 | Party Cloudy | Bare
 |  | new_admin | A | South | Through | 10 | Party Cloudy | Bare
 |  | new_admin | A | South | Right | 10 | Party Cloudy | Bare
 |  | new_admin | A | West | Left | 10 | Party Cloudy | Bare
 |  | new_admin | A | West | Through | 10 | Party Cloudy | Bare
 |  | new_admin | A | West | Right | 10 | Party Cloudy | Bare
 |  | new_admin | A | North | Left | 10 | Party Cloudy | Bare
 |  | new_admin | A | North | Through | 10 | Party Cloudy | Bare
 |  | new_admin | A | North | Right | 10 | Party Cloudy | Bare
 |  | new_admin | B | North | Right | 5 | Party Cloudy | Bare
 |  | new_admin | B | North | Through | 5 | Party Cloudy | Bare
 |  | new_admin | B | North | Left | 5 | Party Cloudy | Bare
 |  | new_admin | B | East | Right | 5 | Party Cloudy | Bare
 |  | new_admin | B | East | Through | 5 | Party Cloudy | Bare
 |  | new_admin | B | East | Left | 5 | Party Cloudy | Bare
 |  | new_admin | B | West | Left | 5 | Party Cloudy | Bare
 |  | new_admin | B | West | Through | 5 | Party Cloudy | Bare
 |  | new_admin | B | West | Right | 5 | Party Cloudy | Bare
 |  | new_admin | B | South | Left | 5 | Party Cloudy | Bare
 |  | new_admin | B | South | Through | 5 | Party Cloudy | Bare
 |  | new_admin | B | South | Right | 5 | Party Cloudy | Bare
 |  | new_admin | A | South | Left | 10 | Overcast | Wet
 |  | new_admin | A | South | Through | 10 | Overcast | Wet
 |  | new_admin | A | South | Right | 10 | Overcast | Wet
 |  | new_admin | B | South | Right | 5 | Overcast | Wet
 |  | new_admin | B | South | Through | 5 | Overcast | Wet
 |  | new_admin | B | South | Left | 5 | Overcast | Wet
 |  | new_admin | A | West | Left | 10 | Overcast | Wet
 |  | new_admin | A | West | Left | 10 | Overcast | Wet
 |  | new_admin | A | West | Left | 10 | Overcast | Wet
 |  | new_admin | A | West | Left | 10 | Overcast | Wet
 |  | new_admin | A | West | Through | 10 | Overcast | Wet
 |  | new_admin | A | West | Right | 10 | Overcast | Wet
 |  | new_admin | B | West | Right | 5 | Overcast | Wet
 |  | new_admin | B | West | Through | 5 | Overcast | Wet
 |  | new_admin | B | West | Left | 5 | Overcast | Wet
 |  | new_admin | A | East | Left | 10 | Overcast | Wet
 |  | new_admin | B | East | Left | 5 | Overcast | Wet
 |  | new_admin | B | East | Through | 5 | Overcast | Wet
 |  | new_admin | A | East | Through | 10 | Overcast | Wet
 |  | new_admin | A | East | Right | 10 | Overcast | Wet
 |  | new_admin | A | East | Right | 10 | Overcast | Wet
 |  | new_admin | A | East | Right | 10 | Overcast | Wet
 |  | new_admin | A | East | Right | 10 | Overcast | Wet
 |  | new_admin | C | East | Right | 1 | Overcast | Wet
 |  | new_admin | B | East | Right | 5 | Overcast | Wet
 |  | new_admin | C | East | Through | 1 | Overcast | Wet
 |  | new_admin | C | East | Left | 1 | Overcast | Wet
 |  | new_admin | B | North | Left | 5 | Overcast | Wet
 |  | new_admin | A | North | Left | 10 | Overcast | Wet
 |  | new_admin | A | North | Left | 10 | Overcast | Wet
 |  | new_admin | A | North | Through | 10 | Overcast | Wet
 |  | new_admin | A | North | Through | 10 | Overcast | Wet
 |  | new_admin | B | North | Right | 5 | Overcast | Wet
 |  | new_admin | B | North | Right | 5 | Overcast | Wet
 |  | new_admin | B | North | Through | 5 | Overcast | Wet
 |  | new_admin | B | North | Through | 5 | Overcast | Wet
 |  | new_admin | B | North | Left | 5 | Overcast | Wet
 |  | new_admin | C | North | Left | 1 | Overcast | Wet
 |  | new_admin | C | North | Through | 1 | Overcast | Wet
 |  | new_admin | C | North | Right | 1 | Overcast | Wet
 |  | new_admin | F | North | Right | 1 | Overcast | Wet
 |  | new_admin | F | North | Through | 1 | Overcast | Wet
 |  | new_admin | F | North | Left | 1 | Overcast | Wet
 |  | new_admin | E | North | Left | 1 | Overcast | Wet
 |  | new_admin | G | South | Right | 1 | Overcast | Wet
 |  | new_admin | G | South | Through | 1 | Overcast | Wet
 |  | new_admin | G | South | Left | 1 | Overcast | Wet
 |  | new_admin | H | South | Left | 1 | Overcast | Wet
 |  | new_admin | H | South | Through | 1 | Overcast | Wet
 |  | new_admin | H | South | Right | 1 | Overcast | Wet
 |  | new_admin | G | West | Left | 1 | Overcast | Wet
 |  | new_admin | G | West | Left | 1 | Overcast | Wet
 |  | new_admin | G | West | Left | 1 | Overcast | Wet
 |  | new_admin | G | West | Through | 1 | Overcast | Wet
 |  | new_admin | G | West | Through | 1 | Overcast | Wet
 |  | new_admin | G | West | Right | 1 | Overcast | Wet
 |  | new_admin | G | West | Right | 1 | Overcast | Wet
 |  | new_admin | H | West | Right | 1 | Overcast | Wet
 |  | new_admin | H | West | Through | 1 | Overcast | Wet
 |  | new_admin | H | West | Left | 1 | Overcast | Wet
 |  | new_admin | H | West | Left | 1 | Overcast | Wet
 |  | new_admin | H | West | Left | 1 | Overcast | Wet
 |  | new_admin | H | West | Left | 1 | Overcast | Wet
 |  | new_admin | H | West | Left | 1 | Overcast | Wet
 |  | new_admin | G | East | Left | 1 | Overcast | Wet
 |  | new_admin | G | East | Left | 1 | Overcast | Wet
 |  | new_admin | G | East | Through | 1 | Overcast | Wet
 |  | new_admin | G | East | Right | 1 | Overcast | Wet
 |  | new_admin | G | East | Right | 1 | Overcast | Wet
 |  | new_admin | G | East | Right | 1 | Overcast | Wet
 |  | new_admin | G | East | Right | 1 | Overcast | Wet
 |  | new_admin | G | East | Right | 1 | Overcast | Wet
 |  | new_admin | G | East | Right | 1 | Overcast | Wet
 |  | new_admin | G | East | Right | 1 | Overcast | Wet
 |  | new_admin | G | East | Right | 1 | Overcast | Wet
 |  | new_admin | H | East | Right | 1 | Overcast | Wet
 |  | new_admin | H | East | Through | 1 | Overcast | Wet
 |  | new_admin | H | East | Left | 1 | Overcast | Wet
 |  | new_admin | G | East | Left | 10 | Overcast | Wet
 |  | new_admin | G | East | Left | 10 | Overcast | Wet
 |  | new_admin | G | East | Through | 10 | Overcast | Wet
 |  | new_admin | G | East | Right | 10 | Overcast | Wet
 |  | new_admin | J | North | Left | 1 | Overcast | Wet
 |  | new_admin | J | North | Through | 1 | Overcast | Wet
 |  | new_admin | J | North | Right | 1 | Overcast | Wet
 |  | new_admin | K | North | Right | 1 | Overcast | Wet
 |  | new_admin | L | North | Right | 1 | Overcast | Wet
 |  | new_admin | L | North | Through | 1 | Overcast | Wet
 |  | new_admin | L | North | Left | 1 | Overcast | Wet
 |  | new_admin | I | North | Right | 1 | Overcast | Wet
 |  | new_admin | I | North | Through | 1 | Overcast | Wet
 |  | new_admin | H | North | left | 1 | Overcast | Wet
 |  | new_admin | H | North | Through | 1 | Overcast | Wet
 |  | new_admin | M | South | Left | 1 | Overcast | Wet
 |  | new_admin | M | South | Through | 1 | Overcast | Wet
 |  | new_admin | M | South | Right | 1 | Overcast | Wet
 |  | new_admin | M | South | Right | 1 | Overcast | Wet
 |  | new_admin | M | South | Right | 1 | Overcast | Wet
 |  | new_admin | M | South | Right | 1 | Overcast | Wet
 |  | new_admin | M | South | Right | 1 | Overcast | Wet
 |  | new_admin | M | South | Right | 1 | Overcast | Wet
 |  | new_admin | N | East | Left | 1 | Overcast | Wet
 |  | new_admin | N | East | Left | 1 | Overcast | Wet
 |  | new_admin | N | East | Through | 1 | Overcast | Wet
 |  | new_admin | N | East | Through | 1 | Overcast | Wet
 |  | new_admin | N | East | Right | 1 | Overcast | Wet
 |  | new_admin | M | East | Left | 1 | Overcast | Wet
 |  | new_admin | M | East | Left | 1 | Overcast | Wet
 |  | new_admin | M | East | Through | 1 | Overcast | Wet
 |  | new_admin | N | East | Through | 1 | Rain | Wet
 |  | new_admin | N | East | Through | 1 | Rain | Wet
 |  | new_admin | N | East | Left | 1 | Rain | Wet
 |  | new_admin | N | East | Right | 1 | Rain | Wet
 |  | new_admin | M | East | Right | 1 | Rain | Wet
 |  | new_admin | M | East | Through | 1 | Rain | Wet
 |  | new_admin | M | East | Left | 1 | Rain | Wet
 |  | new_admin | M | East | Left | 1 | Rain | Wet
END | END | END | END | END | END | END | END | END | END | END | END | END | END | END | END | END | END | END | END | END | END | END
 | Final Weather and [NAME]
 | Time Start | Time End |  | Weather | Road