Spreadsheet: 728664d1618565434-help-with-concatenate-and-countif-to-create-automatic-reference-number-example-data-1-
Sheet: Applications

Date of submission | Please confirm you have read the guidance available at _________ | Have you spoken to the person you are applying for support from | Your title | Your name | Name of organisation | Charity or company registration number (if applicable) | Your position in the organisation | Address of organisation | E-mail address | Bank account or building society details | Project description | Start date | Anticipated spend date | Total cost of activity | Amount applying for | How will any funding gaps be filled | Name | Please confirm that you accept the following Terms and Conditions. | Reference
2021-04-15 12:31:23 | I confirm I have read and understood the Locality Budget application guidance | Yes | Mr | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 1000 | 500 | Reserves | [NAME], [NAME] | I accept the terms and conditions as laid out above.
2021-04-15 12:48:53 | I confirm I have read and understood the Locality Budget application guidance | Yes | Mr | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 1000 | 500 | Reserves | Jones, [NAME] | I accept the terms and conditions as laid out above.
2021-04-16 00:00:00 | I confirm I have read and understood the Locality Budget application guidance | Yes | Mr | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 1000 | 500 | Reserves | Jones, [NAME] | I accept the terms and conditions as laid out above.
2021-04-17 00:00:00 | I confirm I have read and understood the Locality Budget application guidance | Yes | Mr | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 1000 | 500 | Reserves | [NAME], [NAME] | I accept the terms and conditions as laid out above.
2021-04-18 00:00:00 | I confirm I have read and understood the Locality Budget application guidance | Yes | Mr | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 1000 | 500 | Reserves | Howell, [NAME] | I accept the terms and conditions as laid out above.
2021-04-19 00:00:00 | I confirm I have read and understood the Locality Budget application guidance | Yes | Mr | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 1000 | 500 | Reserves | Howell, [NAME] | I accept the terms and conditions as laid out above.
2021-04-20 00:00:00 | I confirm I have read and understood the Locality Budget application guidance | Yes | Mr | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 1000 | 500 | Reserves | [NAME], [NAME] | I accept the terms and conditions as laid out above.
2021-04-21 00:00:00 | I confirm I have read and understood the Locality Budget application guidance | Yes | Mr | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 1000 | 500 | Reserves | Jones, [NAME] | I accept the terms and conditions as laid out above.
2021-04-22 00:00:00 | I confirm I have read and understood the Locality Budget application guidance | Yes | Mr | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 1000 | 500 | Reserves | Stephens, [NAME] | I accept the terms and conditions as laid out above.
2021-04-23 00:00:00 | I confirm I have read and understood the Locality Budget application guidance | Yes | Mr | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 1000 | 500 | Reserves | Stephens, [NAME] | I accept the terms and conditions as laid out above.
2021-04-24 00:00:00 | I confirm I have read and understood the Locality Budget application guidance | Yes | Mr | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 1000 | 500 | Reserves | Howell, [NAME] | I accept the terms and conditions as laid out above.
2021-04-25 00:00:00 | I confirm I have read and understood the Locality Budget application guidance | Yes | Mr | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 1000 | 500 | Reserves | [NAME], [NAME] | I accept the terms and conditions as laid out above.
2021-04-26 00:00:00 | I confirm I have read and understood the Locality Budget application guidance | Yes | Mr | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | XXXXXXXX | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 1000 | 500 | Reserves | Jones, [NAME] | I accept the terms and conditions as laid out above.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jones, [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], [NAME]