Count SLA misses and restart time when it hits the threshold
I have 3 fields that need to be evaluated in this formula.
1. file name
So if a file fails the SLA 2 times then the time needs to reset to 15 months else I need a counter that counts down the days from the last SLA miss starting with 15 months.
SLA is a formula that says if time is >15:01 then "Miss" else "Pass"
Can anyone help me?