Hello all,
I am inquiring about this here because i am seriously stuck. I don't know if the solution is simple or complex in truth i don't exactly know how to search for it.
Here is a little background followed by my problem. I work on the service desk of a medium sized company we are a small team and we wear many hats. One of my new hats involves me creating a dashboard to shows generic information about the state of things in IT (regarding Requests and Incidents fulfillment) so we can establish KPI's. Our ticketing system does not allow the creation of a report/dashboard so everything needs to be done in Excel or other tools.
I found myself in trouble when i tried to establish if a request had passed a certain threshold lets say 10 days past it's requested target date.
I can get the information easily enough for 90% of the requests we have by using a simple IF formula =IF([@[Completed_Date]]-[@[Target_Date]=]=>10, "Breached", "Within SLA")but this is where it gets dicey.
In order to solve a different problem that i won't go into here all of our HR related requests use a different Target Date field so it shows up in a different column when i extract the data to excel.
My question is how do i get excel to look in a different column when the Request_Type is HR Related. I have dropped an example to help clarify things since i feel like my question is as clear as mud.
Link to file: http://www.filedropper.com/example_8
I am inquiring about this here because i am seriously stuck. I don't know if the solution is simple or complex in truth i don't exactly know how to search for it.
Here is a little background followed by my problem. I work on the service desk of a medium sized company we are a small team and we wear many hats. One of my new hats involves me creating a dashboard to shows generic information about the state of things in IT (regarding Requests and Incidents fulfillment) so we can establish KPI's. Our ticketing system does not allow the creation of a report/dashboard so everything needs to be done in Excel or other tools.
I found myself in trouble when i tried to establish if a request had passed a certain threshold lets say 10 days past it's requested target date.
I can get the information easily enough for 90% of the requests we have by using a simple IF formula =IF([@[Completed_Date]]-[@[Target_Date]=]=>10, "Breached", "Within SLA")but this is where it gets dicey.
In order to solve a different problem that i won't go into here all of our HR related requests use a different Target Date field so it shows up in a different column when i extract the data to excel.
My question is how do i get excel to look in a different column when the Request_Type is HR Related. I have dropped an example to help clarify things since i feel like my question is as clear as mud.
Link to file: http://www.filedropper.com/example_8