Spreadsheet: 593201d1539033148-pulling-previous-averages-based-on-combo-box-example
Sheet: Data

Data Entered | User | Supervisor | Element | Plant | Score 1 | Score 2 | Score 3 | Score 4 | Average |  |  |  |  |  |  | Month
2018-08-01 00:00:00 | [NAME] | [NAME] | Element1 | Plant1 | 2 |  |  |  |  |  |  |  |  |  |  | 2018-05-01 00:00:00
2018-08-01 00:00:00 | [NAME] | [NAME] | Element2 | Plant1 | 4 | 2 |  |  |  |  |  |  |  |  |  | 2018-06-01 00:00:00
2018-08-01 00:00:00 | [NAME] | [NAME] | Element3 | Plant1 | 3 |  |  |  |  |  |  |  |  |  |  | 2018-07-01 00:00:00
2018-08-01 00:00:00 | [NAME] | [NAME] | Element1 | Plant2 | 2 |  |  |  |  |  |  |  |  |  |  | 2018-08-01 00:00:00
2018-08-01 00:00:00 | [NAME] | [NAME] | Element2 | Plant2 | 1 | 3 |  |  |  |  |  |  |  |  |  | 2018-09-01 00:00:00
2018-08-01 00:00:00 | [NAME] | [NAME] | Element3 | Plant2 | 4 |  |  |  |  |  |  |  |  |  |  | 2018-10-01 00:00:00
2018-08-01 00:00:00 | [NAME] | [NAME] | Element1 | Plant3 | 2 |  |  |  |  |  |  |  |  |  |  | 2018-11-01 00:00:00
2018-08-01 00:00:00 | [NAME] | [NAME] | Element2 | Plant3 | 3 | 1 |  |  |  |  |  |  |  |  |  | 2018-12-01 00:00:00
2018-08-01 00:00:00 | [NAME] | [NAME] | Element3 | Plant3 | 2 |  |  |  |  |  |  |  |  |  |  | 2019-01-01 00:00:00
2018-09-01 00:00:00 | [NAME] | [NAME] | Element1 | Plant1 | 1 |  |  |  |  |  |  |  |  |  |  | 2019-02-01 00:00:00
2018-09-01 00:00:00 | [NAME] | [NAME] | Element2 | Plant1 | 3 | 1 |  |  |  |  |  |  |  |  |  | 2019-03-01 00:00:00
2018-09-01 00:00:00 | [NAME] | [NAME] | Element3 | Plant1 | 1 |  |  |  |  |  |  |  |  |  |  | 2019-04-01 00:00:00
2018-09-01 00:00:00 | [NAME] | [NAME] | Element1 | Plant2 | 2 |  |  |  |  |  |  |  |  |  |  | 2019-05-01 00:00:00
2018-09-01 00:00:00 | [NAME] | [NAME] | Element2 | Plant2 | 2 | 2
2018-09-01 00:00:00 | [NAME] | [NAME] | Element3 | Plant2 | 5
2018-09-01 00:00:00 | [NAME] | [NAME] | Element1 | Plant3 | 3
2018-09-01 00:00:00 | [NAME] | [NAME] | Element2 | Plant3 | 3 | 3
2018-09-01 00:00:00 | [NAME] | [NAME] | Element3 | Plant3 | 1
2018-07-01 00:00:00 | [NAME] | [NAME] | Element1 | Plant1 | 4
2018-07-01 00:00:00 | [NAME] | [NAME] | Element2 | Plant1 | 2 | 2
2018-07-01 00:00:00 | [NAME] | [NAME] | Element3 | Plant1 | 2
2018-07-01 00:00:00 | [NAME] | [NAME] | Element1 | Plant2 | 3
2018-07-01 00:00:00 | [NAME] | [NAME] | Element2 | Plant2 | 4 | 3
2018-07-01 00:00:00 | [NAME] | [NAME] | Element3 | Plant2 | 5
2018-07-01 00:00:00 | [NAME] | [NAME] | Element1 | Plant3 | 5
2018-07-01 00:00:00 | [NAME] | [NAME] | Element2 | Plant3 | 1 | 1
2018-07-01 00:00:00 | [NAME] | [NAME] | Element3 | Plant3 | 2
2018-06-01 00:00:00 | [NAME] | [NAME] | Element1 | Plant1 | 1
2018-06-01 00:00:00 | [NAME] | [NAME] | Element2 | Plant1 | 1 | 2
2018-06-01 00:00:00 | [NAME] | [NAME] | Element3 | Plant1 | 2
2018-06-01 00:00:00 | [NAME] | [NAME] | Element1 | Plant2 | 3
2018-06-01 00:00:00 | [NAME] | [NAME] | Element2 | Plant2 | 3 | 5
2018-06-01 00:00:00 | [NAME] | [NAME] | Element3 | Plant2 | 1
2018-06-01 00:00:00 | [NAME] | [NAME] | Element1 | Plant3 | 1
2018-06-01 00:00:00 | [NAME] | [NAME] | Element2 | Plant3 | 1 | 4
2018-06-01 00:00:00 | [NAME] | [NAME] | Element3 | Plant3 | 4
2018-10-01 00:00:00 | [NAME] | [NAME] | Element1 | Plant1 | 5
2018-10-01 00:00:00 | [NAME] | [NAME] | Element2 | Plant1 | 2 | 2
2018-10-01 00:00:00 | [NAME] | [NAME] | Element3 | Plant1 | 4
2018-10-01 00:00:00 | [NAME] | [NAME] | Element1 | Plant2 | 3
2018-10-01 00:00:00 | [NAME] | [NAME] | Element2 | Plant2 | 1 | 3
2018-10-01 00:00:00 | [NAME] | [NAME] | Element3 | Plant2 | 4
2018-10-01 00:00:00 | [NAME] | [NAME] | Element1 | Plant3 | 2
2018-10-01 00:00:00 | [NAME] | [NAME] | Element2 | Plant3 | 1 | 5
2018-10-01 00:00:00 | [NAME] | [NAME] | Element3 | Plant3 | 2