Spreadsheet: 859477d1707845845-stack-up-values-while-having-a-new-row-with-the-existing-values-from-previous-rows-cmp-survey-all-fields-test
Sheet: Original

Start Date | End Date | Progress | Duration (in seconds) | Finished | Recorded Date | Recipient Last Name | Recipient First Name | Recipient Email | Distribution Channel | User Language | 1- What department are you in? - Selected Choice | 1- What department are you in? - Other - Text | 2- Does your study requirea specific order? | 3- List the study ID(s) that require modification. If entering multiple study IDs, SEPARATE them by a semi-colon (;) ONLY. If study IDs are not separated by semi-colon, your responses will NOT be captured correctly. | 4.	Is there anything else you would like to share with us?
2024-02-06 11:00:10 | 2024-02-06 11:00:25 | 100 | 14 | True | 2024-02-06 11:00:26.167000 | poppins | [NAME] | [EMAIL] | email | EN | [NAME] |  | No
2024-02-06 11:03:25 | 2024-02-06 11:03:51 | 100 | 25 | True | 2024-02-06 11:03:51.685000 | poppins | [NAME] | [EMAIL] | email | EN | [NAME] |  | Yes | 1234-5687;58256-2589;1259-05869
2024-02-06 11:03:58 | 2024-02-06 11:04:30 | 100 | 32 | True | 2024-02-06 11:04:30.994000 | poppins | [NAME] | [EMAIL] | email | EN | Dermatology |  | Yes | 123-4567;3456-1234;2022358; only included 3
2024-02-06 11:06:05 | 2024-02-06 11:07:12 | 100 | 67 | True | 2024-02-06 11:07:13.520000 | Doe | [NAME] | [EMAIL] | email | EN | GI |  | Yes | 202050472;2020444;2023-0999 | 1st
2024-02-06 11:07:22 | 2024-02-06 11:07:29 | 100 | 7 | True | 2024-02-06 11:07:30.240000 | Doe | [NAME] | [EMAIL] | email | EN | Dermatology |  | No
2024-02-06 11:07:38 | 2024-02-06 11:08:18 | 100 | 40 | True | 2024-02-06 11:08:19.489000 | Doe | [NAME] | [EMAIL] | email | EN | Leukemia |  | Yes | 202200111; 2023444; 2019333 | 2nd
2024-02-06 11:07:09 | 2024-02-06 11:08:20 | 100 | 71 | True | 2024-02-06 11:08:21.291000 | KO | [NAME] | [EMAIL] | email | EN | heart |  | Yes | 20242024 | Ed first survey for 2024-2024
2024-02-06 11:08:26 | 2024-02-06 11:09:05 | 100 | 38 | True | 2024-02-06 11:09:05.529000 | Doe | [NAME] | [EMAIL] | email | EN | GU |  | Yes | 20190001; nci0923434; alliance000111 | 3rd
2024-02-06 11:08:34 | 2024-02-06 11:09:24 | 100 | 49 | True | 2024-02-06 11:09:25.039000 | KO | [NAME] | [EMAIL] | email | EN | Kidney |  | Yes | 2024024 | [NAME] 2nd survey for 2024-2024
2024-02-06 11:09:33 | 2024-02-06 11:11:28 | 100 | 115 | True | 2024-02-06 11:11:29.644000 | KO | [NAME] | [EMAIL] | email | EN | Kidney |  | Yes | 20-2025;202026;2025027; 20028 | [NAME] added space after semicolon for 2025-2028
2024-02-06 11:11:42 | 2024-02-06 11:11:51 | 100 | 9 | True | 2024-02-06 11:11:52.130000 | KO | [NAME] | [EMAIL] | email | EN | Kidney |  | No
2024-02-06 11:13:32 | 2024-02-06 11:14:08 | 100 | 35 | True | 2024-02-06 11:14:08.750000 | Doe | [NAME] | [EMAIL] | email | EN | Surgery |  | Yes | 2022-11,20888,2033999 | 4th
2024-02-06 11:12:03 | 2024-02-06 11:14:30 | 100 | 147 | True | 2024-02-06 11:14:30.938000 | KO | [NAME] | [EMAIL] | email | EN | Kidney |  | Yes | 2024025
2024-02-06 11:14:38 | 2024-02-06 11:14:57 | 100 | 18 | True | 2024-02-06 11:14:57.876000 | KO | [NAME] | [EMAIL] | email | EN | Kidney |  | No
2024-02-06 11:15:16 | 2024-02-06 11:16:28 | 100 | 72 | True | 2024-02-06 11:16:29.476000 | KO | [NAME] | [EMAIL] | email | EN | Kidney |  | Yes | 2024025 | [NAME]. I need to change the 2024-2025 to "No". We don't need [NAME] for this study
2024-02-06 12:12:20 | 2024-02-06 12:13:33 | 100 | 72 | True | 2024-02-06 12:13:33.938000 | [NAME] | [NAME] | [EMAIL] | email | EN | Head |  | Yes | 2023; [PHONE]; 20232354 | No. I am still testing if this looks correct.
2024-02-06 12:13:47 | 2024-02-06 12:13:56 | 100 | 8 | True | 2024-02-06 12:13:56.815000 | [NAME] | [NAME] | [EMAIL] | email | EN | Head |  | No
2024-02-06 15:32:56 | 2024-02-06 15:34:38 | 100 | 102 | True | 2024-02-06 15:34:39.255000 | [NAME] | [NAME] | [EMAIL] | email | EN | Bladder |  | Yes | 2023-0987; 2022-1234; 2021-1234 | Test again....see how the multiple studies are listed
2024-02-13 09:30:32 | 2024-02-13 09:34:59 | 100 | 266 | True | 2024-02-13 09:34:59.797000 | [NAME] | [NAME] | [EMAIL] | email | EN | Other | [NAME] | Yes | Pr; Phuca: Pit, Po:co | Yes; winter is coming; i'll be back
2024-02-13 09:33:07 | 2024-02-13 09:36:05 | 100 | 178 | True | 2024-02-13 09:36:06.402000 | [NAME] | [NAME] | [EMAIL] | email | EN | GU |  | Yes | 2023-*-0987 | none