Hi All,
Apologies if i'm not posting in the correct section. I tried to find the most appropriate discussion thread.
This is quite a complicated one (well for me at least) so i'll really be impressed if this can be solved.
What i'm trying to do is calculate and populate the SLA Deadline cell (in date format).
this can be calculated by searching the Ticket type cell for a specific word and numerical value and adding the number of days attributed to the combination of the word and number to the Created Date. The answer must populate in the SLA Deadline column
If Ticket type contains "bug fix" and "4" then add 0 working days to Created Date
If Ticket type contains "bug fix" and "5" then add 1 working days to Created Date
So for example:
if Ticket type contains the words "bug fix" and "5"
then SLA Date = 2019/01/02 (as it adds +1 [working days] to the created date)
Working Days = Mon-Fri
What Formula would i use in the SLA Deadline cells to achieve the below result as an example?
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Ticket Type[/TD]
[TD]Created Date[/TD]
[TD]SLA Deadline[/TD]
[/TR]
[TR]
[TD][TABLE="width: 734"]
<tbody>[TR]
[TD="width: 734"]bug fix | Group - Availability & Fill Rate | 4[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]2019/01/01[/TD]
[TD]2019/01/01[/TD]
[/TR]
[TR]
[TD]bug fix | Group - Availability & Fill Rate | 5[/TD]
[TD]2019/01/01[/TD]
[TD]2019/01/02[/TD]
[/TR]
</tbody>[/TABLE]
hope this makes sense
Apologies if i'm not posting in the correct section. I tried to find the most appropriate discussion thread.
This is quite a complicated one (well for me at least) so i'll really be impressed if this can be solved.
What i'm trying to do is calculate and populate the SLA Deadline cell (in date format).
this can be calculated by searching the Ticket type cell for a specific word and numerical value and adding the number of days attributed to the combination of the word and number to the Created Date. The answer must populate in the SLA Deadline column
If Ticket type contains "bug fix" and "4" then add 0 working days to Created Date
If Ticket type contains "bug fix" and "5" then add 1 working days to Created Date
So for example:
if Ticket type contains the words "bug fix" and "5"
then SLA Date = 2019/01/02 (as it adds +1 [working days] to the created date)
Working Days = Mon-Fri
What Formula would i use in the SLA Deadline cells to achieve the below result as an example?
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Ticket Type[/TD]
[TD]Created Date[/TD]
[TD]SLA Deadline[/TD]
[/TR]
[TR]
[TD][TABLE="width: 734"]
<tbody>[TR]
[TD="width: 734"]bug fix | Group - Availability & Fill Rate | 4[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]2019/01/01[/TD]
[TD]2019/01/01[/TD]
[/TR]
[TR]
[TD]bug fix | Group - Availability & Fill Rate | 5[/TD]
[TD]2019/01/01[/TD]
[TD]2019/01/02[/TD]
[/TR]
</tbody>[/TABLE]
hope this makes sense