Spreadsheet: 757651d1638378239-formula-to-compare-values-and-then-edit-report
Sheet: After

USER_ID | ACTIVE | FIRST_NAME | Middle Name | LAST_NAME | [NAME] | Work Phone | CRT Number | OBC_MGR_ID | MGR_ID | Placement ID | Internal ID | MGR_NAME | OBC_BRANCH_ID | BRANCH_ID | OSJ_NAME | STREET2 | STREET | CITY | STATE_CODE | ZIP | Signed Up | Installed
1234 | Active | [NAME] |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 0 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | CA | 55512 | 2021-11-15 00:00:00 | No | [EMAIL]
5678 | Active | [NAME] |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 0 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | NJ | 55512 | 2021-11-12 00:00:00 | Yes | [EMAIL]
1111 | Active | [NAME] |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 0 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | CA | 55512 | 2021-11-15 00:00:00 | Yes | [EMAIL]
2222 | Active | [NAME] |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 1 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | TX | 55512 | 2021-11-15 00:00:00 | Yes | [EMAIL]
3333 | Active | [NAME] |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 1 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | PA | 55512 | 2021-11-15 00:00:00 | Yes | [EMAIL]
4444 | Active | Janice |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 1 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | CA | 55512 | 2021-11-19 00:00:00 | Yes | [EMAIL]
5555 | Active | Michelle |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 0 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | NY | 55512 | 2021-11-15 00:00:00 | Yes | [EMAIL]
6666 | Active | Mac |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 0 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | MN | 55512 | 2021-11-15 00:00:00 | Yes | [EMAIL]
7777 | Active | [NAME] |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 0 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | MO | 55512 | 2021-11-15 00:00:00 | No | [EMAIL]
8888 | Active | [NAME] |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 0 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | FL | 55512 | 2021-11-15 00:00:00 | No
9999 | Active | Jeffery |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 0 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | NY | 55512 | 2021-11-15 00:00:00 | No
1010 | Active | [NAME] |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 0 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | NY | 55512 | 2021-11-17 00:00:00 | No
1aaa | Active | [NAME] |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 0 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | AR | 55512 | 2021-11-21 00:00:00 | No
2bbb | Active | [NAME] |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 1 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | OR | 55512 | 2021-11-15 00:00:00 | No
3ccc | Active | [NAME] |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 0 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | CA | 55512 | 2021-11-15 00:00:00 | Yes
4ddd | Active | [NAME] |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 0 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | CO | 55512 | 2021-11-15 00:00:00 | No
5eee | Active | [NAME] |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 1 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | AR | 55512 | 2021-11-22 00:00:00 | No
6fff | Active | Anette |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 1 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | WA | 55512 | 2021-11-15 00:00:00 | No
7ggg | Active | [NAME] |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 0 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | TN | 55512 | 2021-11-15 00:00:00 | No
8hhhh | Active | Fred |  | Doe | [EMAIL] |  |  | xxxx | x4x4 | 0 | 93199 | [NAME] | x5x5 | x6x6 | [NAME] |  | 123 Main St | Temp City | NY | 55512 | 2021-11-15 00:00:00 | Yes