IF Formula assistance

[NeilKloster]

Hello, 

I have an IF statement under my 'RAW' tab and I think that should be a quick fix for this group: 

The IF statement under my 'Resources' column does exactly I want it to, but I have my 'Resource Hours' column set to ([Resources]*60) to show in minutes.  This works great if I have Salesforce cases represented, but if it is 'Self-Reported Time' - then not sure much, because I just want the raw processing time.  How can I fix this?

I'm also attaching a copy of my file to see if anyone can help me out?

Basically, everything works as it should EXCEPT if I have a 'Self-Reported entry' - I need a formula that will just read the processing time (WITHOUT) multiplying it by 60.  

Any thoughts?

[#2 · Accepted solution]

@NeilKloster 

Use this formula for Resource Hours:

=[@Resources]*IF([@[Tracking Type]]="Self-Reported Time",1,60)

[#3]

Boom!! Thank you!!

[#4]

@Hans Vogelaar

Apologies - but I have another issue that I just noticed. For my 'Resource' Column, I then need it divide that raw processing time for those 'Self-Reported Cases' by 60. What change would I need to make?

[#5]

@NeilKloster 

I think

=IF([@[Tracking Type]]="Self-Reported Time",[@[Processing Time]]/60, INDEX(Shared_Services_Expectations[Expectations (Hours)], MATCH([@[Service Level 1]]&[@[Service Level 2]], Shared_Services_Expectations[Category Level 1]&Shared_Services_Expectations[Category Level 2], 0)))*[@[Service Count]]

but there seems to be a problem with referring to the Shared_Services_Expectations table - the formula somehow doesn't recognize it. Perhaps it's just my PC.

[#6]

@Hans Vogelaar 

It's not just your PC.  It does this to the Resource Hours Column: 

Which granted is not a HUGE deal - it all still works, but would rather figure out a way to just have the processing time show there if it is a Self-Reported entry.  Not sure if there is a way to figure that piece out or not?  

Appreciate your help! 

[#7]

@Hans Vogelaar 

Attached is another file - similar concept, different processes - but here is the formula that they used under the RAW tab: 

=IF([@[Service Type]]="Self-Reported Time",[@[Processing Time]],VLOOKUP([@Service],Expectations[#All],2,FALSE)*[@[Service Count]]) 

Not sure how to get that to translate over to mine or not?  Also not sure why my expectations table will not connect as well?

[#8]

@NeilKloster 

I think we were making it too complicated. See the attached version.

[#9]

@Hans Vogelaar - you are amazing! And yes, looks like we were! Thank you SO much for the assistance.