Spreadsheet: 741635d1627220387-two-if-statements-book1
Sheet: SNOW - Raw Data

Number | Task type | Priority | State | Parent | Caller [Incident] | Location | Zone | Project | Created | Updated | Resolved [Incident] | Closed | Created by | Opened by | Logged By Group | Assigned to | Assignment group | Resolved by [Incident] | Short description | Description | Configuration item | Contact type | Company | Made SLA | Resolve time [Incident] | Resolve Time [Request] | External Reference Number [Incident] | External Supplier [Incident] | Escalate to Manager [Incident] | H.Created | After Hours Or Weekeday | AM or PM | Week Day or Weekend | Day of Week | R.Time | C.Month | R.Month | R.Week | L.Week | L.Month | C.Year | counter | L.Team | R.Team | C.Team | Same Day | <24 | [NAME]
INC000000028 | Incident | 2 - High | Closed |  |  |  |  |  | 2021-07-17 00:36:42 | 2021-07-24 02:00:03 | 2021-07-17 01:11:14 | 2021-07-24 02:00:03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
INC000000057 | Incident | 2 - High | Closed |  |  |  |  |  | 2021-07-17 03:42:43 | 2021-07-24 08:00:09 | 2021-07-17 07:09:48 | 2021-07-24 08:00:09 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
INC000000055 | Incident | 2 - High | Closed |  |  |  |  |  | 2021-07-17 05:23:54 | 2021-07-24 12:00:08 | 2021-07-17 11:52:51 | 2021-07-24 12:00:08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
SCTASK000010951 | Catalog Task | 3- Low | Closed [NAME] |  |  |  |  |  | 2021-07-17 10:11:42 | 2021-07-18 07:41:26 |  | 2021-07-18 07:41:26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
INC000000254 | Incident | 3 - Moderate | Resolved |  |  |  |  |  | 2021-07-17 10:16:24 | 2021-07-24 12:00:03 | 2021-07-17 11:55:15 | 2021-07-24 12:00:03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
INC000000655 | Incident | 3 - Moderate | Resolved |  |  |  |  |  | 2021-07-17 21:40:35 | 2021-07-19 10:07:11 | 2021-07-19 10:07:11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
INC000000669 | Incident | 2 - High | Resolved |  |  |  |  |  | 2021-07-17 22:29:22 | 2021-07-17 22:57:24 | 2021-07-17 22:57:24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
INC000000810 | Incident | 2 - High | Resolved |  |  |  |  |  | 2021-07-18 10:17:14 | 2021-07-19 12:39:37 | 2021-07-18 23:32:18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
INC000001091 | Incident | 3 - Moderate | Resolved |  |  |  |  |  | 2021-07-18 16:31:58 | 2021-07-19 13:20:37 | 2021-07-19 10:53:59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
INC000001094 | Incident | 2 - High | Resolved |  |  |  |  |  | 2021-07-18 17:41:49 | 2021-07-19 06:47:20 | 2021-07-18 23:32:18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
INC000001216 | Incident | 1 - Critical | In Progress |  |  |  |  |  | 2021-07-18 21:32:46 | 2021-07-24 11:46:46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
INC000001214 | Incident | 3 - Moderate | Resolved |  |  |  |  |  | 2021-07-18 21:35:40 | 2021-07-19 15:06:28 | 2021-07-19 01:35:35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
INC000001460 | Incident | 3 - Moderate | Resolved |  |  |  |  |  | 2021-07-19 07:59:58 | 2021-07-19 08:02:13 | 2021-07-19 08:02:13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
SCTASK000013016 | Catalog Task | 3- Low | Closed [NAME] |  |  |  |  |  | 2021-07-19 08:18:05 | 2021-07-19 09:46:34 |  | 2021-07-19 09:46:35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
SCTASK000013060 | Catalog Task | 3- Low | Closed [NAME] |  |  |  |  |  | 2021-07-19 08:18:13 | 2021-07-19 09:48:33 |  | 2021-07-19 09:48:33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
SCTASK000013104 | Catalog Task | 3- Low | Closed [NAME] |  |  |  |  |  | 2021-07-19 08:18:22 | 2021-07-19 09:50:48 |  | 2021-07-19 09:50:48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
SCTASK000013148 | Catalog Task | 3- Low | Closed [NAME] |  |  |  |  |  | 2021-07-19 08:18:29 | 2021-07-19 09:53:42 |  | 2021-07-19 09:53:42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
SCTASK000013194 | Catalog Task | 3- Low | Closed [NAME] |  |  |  |  |  | 2021-07-19 08:18:37 | 2021-07-19 09:58:55 |  | 2021-07-19 09:58:55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
SCTASK000013239 | Catalog Task | 3- Low | Closed [NAME] |  |  |  |  |  | 2021-07-19 08:18:48 | 2021-07-19 09:59:59 |  | 2021-07-19 09:59:59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
SCTASK000013283 | Catalog Task | 3- Low | Closed [NAME] |  |  |  |  |  | 2021-07-19 08:18:57 | 2021-07-19 10:00:50 |  | 2021-07-19 10:00:51 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
SCTASK000013328 | Catalog Task | 3- Low | Closed [NAME] |  |  |  |  |  | 2021-07-19 08:19:05 | 2021-07-19 10:02:47 |  | 2021-07-19 10:02:47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
INC000001608 | Incident | 3 - Moderate | Resolved |  |  |  |  |  | 2021-07-19 08:19:14 | 2021-07-19 08:29:51 | 2021-07-19 08:29:51 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
I would like column AU to determine if the column is either "closed or resolved" but if it says "closed complete" put in "Task Review". If it helps if column A starts with "SCTASK" then insert "task review".