Spreadsheet: 832886d1686654773-issue-with-part-of-an-let-function-with-a-if-and-formula-not-giving-correct-information-sample
Sheet: New Report

 |  |  |  |  |  |  |  |  |  |  | Date of Old Report: |  | 2023-06-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Date of New Report: |  | 2023-06-13 00:00:00
Participant's_Name | EMPLOYEE_NUMBER | Booking_ID | Serv ice_Booking_Type | Support_Category | Support_Item | Start_Date | End_Date | Allocated_Amount | Remaining_Amount | Accrual_Amount | Last_Modif_Date | Status | Status of Plan |  | What should Show in N Column
[NAME] | 123456789 | 987654321 | Extra Booking | Category1 |  | 2023-01-01 00:00:00 | 2024-12-31 00:00:00 | 500 | 500 |  | 2023-06-10 00:00:00 | Active |  |  | Extended
[NAME] | 123456789 | 789456123 | Normal Funded Booking | Category2 |  | 2023-01-01 00:00:00 | 2024-12-31 00:00:00 | 1000 | 1000 |  | 2023-06-10 00:00:00 | Active |  |  | Extended
[NAME] | 123456789 | 587496312 | Extra Booking | Category3 |  | 2023-01-01 00:00:00 | 2024-12-31 00:00:00 | 2000 | 2000 |  | 2023-06-10 00:00:00 | Active |  |  | Extended
[NAME] | 123456789 | 987654321 | Extra Booking | Category4 |  | 2023-01-01 00:00:00 | 2024-12-31 00:00:00 | 3000 | 3000 |  | 2023-06-10 00:00:00 | Active |  |  | Extended
[NAME] | 123456789 | 987654321 | Extra Booking | Category5 |  | 2023-01-01 00:00:00 | 2024-12-31 00:00:00 | 4000 | 4000 |  | 2023-06-10 00:00:00 | Active |  |  | Extended
[NAME] | 123456789 | 987654321 | Extra Booking | Category6 |  | 2023-01-01 00:00:00 | 2024-12-31 00:00:00 | 5000 | 5000 |  | 2023-06-10 00:00:00 | Active |  |  | Extended
[NAME] | 123456789 | 987654321 | Extra Booking | Category7 |  | 2023-01-01 00:00:00 | 2024-12-31 00:00:00 | 6000 | 6000 |  | 2023-06-10 00:00:00 | Active |  |  | Extended
PARTICIPANT_NAME | EMPLOYEE_NUMBER | BOOKING_ID | SERVICE_BOOKING_TYPE | SUPPORT_CATEGORY | SUPPORT_ITEM | START_DATE | END_DATE | ALLOCATED_AMOUNT | REMAINING_AMOUNT | ACCRUAL_AMOUNT | LAST_MODIF_DATE | STATUS | Date Downloaded
[NAME] | 123456789 | 987654321 | Extra Booking | Category1 |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 | 500 | 500 |  | 2023-06-05 00:00:00 | Active | 2023-06-09 00:00:00
[NAME] | 123456789 | 789456123 | Normal Funded Booking | Category2 |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 | 1000 | 1000 |  | 2023-06-05 00:00:00 | Active | 2023-06-09 00:00:00
[NAME] | 123456789 | 587496312 | Extra Booking | Category3 |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 | 2000 | 2000 |  | 2023-06-05 00:00:00 | Active | 2023-06-09 00:00:00
[NAME] | 123456789 | 987654321 | Extra Booking | Category4 |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 | 3000 | 3000 |  | 2023-06-05 00:00:00 | Active | 2023-06-09 00:00:00
[NAME] | 123456789 | 987654321 | Extra Booking | Category5 |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 | 4000 | 4000 |  | 2023-06-05 00:00:00 | Active | 2023-06-09 00:00:00
[NAME] | 123456789 | 987654321 | Extra Booking | Category6 |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 | 5000 | 5000 |  | 2023-06-05 00:00:00 | Active | 2023-06-09 00:00:00
[NAME] | 123456789 | 987654321 | Extra Booking | Category7 |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 | 6000 | 6000 |  | 2023-06-05 00:00:00 | Active | 2023-06-09 00:00:00