karmaimages
Board Regular
- Joined
- Oct 1, 2009
- Messages
- 112
- Office Version
- 365
- Platform
- Windows
Hi,
I need to add SLA dates to a report, which change based on the severity and impact of the item logged, I have a table as below:
Would someone be able to help me work out how to add the SLA date based on the other 2 criteria?
I need to add SLA dates to a report, which change based on the severity and impact of the item logged, I have a table as below:
Impact | Severity | Logged Date | SLA |
A | 1 | 01/01/2023 | =Logged Date+2 months |
A | 2 | 01/01/2023 | =Logged Date+2 months |
A | 3 | 01/01/2023 | =Logged Date+2 months |
A | 4 | 01/01/2023 | =Logged Date+2 months |
B | 1 | 01/01/2023 | =Logged Date+9 months |
B | 2 | 01/01/2023 | =Logged Date+9 months |
B | 3 | 01/01/2023 | =Logged Date+9 months |
B | 4 | 01/01/2023 | =Logged Date+9 months |
D | 1 | 01/01/2023 | =Logged Date+9 months |
D | 2 | 01/01/2023 | =Logged Date+9 months |
C | 1 | 01/01/2023 | =Logged Date+12 months |
C | 2 | 01/01/2023 | =Logged Date+12 months |
C | 3 | 01/01/2023 | =Logged Date+12 months |
C | 4 | 01/01/2023 | =Logged Date+12 months |
D | 3 | 01/01/2023 | =Logged Date+12 months |
D | 4 | 01/01/2023 | =Logged Date+12 months |
Would someone be able to help me work out how to add the SLA date based on the other 2 criteria?