Hi, I hope you can help as it's driving me mad as I'm sure it's really simple to someone else. The excel help isn't pointing out where exactly the issue is and at this point, won't even let me post it.
I have some metrics, and I want my statement to show me the below:
J2 = Last updated date
E2 = Ticket status
1) I want it to look at all tickets with status (E2) of open, pending or on hold to show me if their last updated date is within the last 3 working days (networkdays).
2) If it is open and the date is within the last 3 days, show me "within KPI", otherwise "missed KPI".
3) If the status (E2) is something else other than my options then I guess it'll show me N/A (Unless I can get it to state "closed" or something too?
=IF(AND((NETWORKDAYS(J2,TODAY()>3,OR(E2="Open",E2="Pending",E2="On Hold")),"Missed KPI","Within KPI")
I have some metrics, and I want my statement to show me the below:
J2 = Last updated date
E2 = Ticket status
1) I want it to look at all tickets with status (E2) of open, pending or on hold to show me if their last updated date is within the last 3 working days (networkdays).
2) If it is open and the date is within the last 3 days, show me "within KPI", otherwise "missed KPI".
3) If the status (E2) is something else other than my options then I guess it'll show me N/A (Unless I can get it to state "closed" or something too?
=IF(AND((NETWORKDAYS(J2,TODAY()>3,OR(E2="Open",E2="Pending",E2="On Hold")),"Missed KPI","Within KPI")