Forum Discussion
IF Formula assistance
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?
Use this formula for Resource Hours:
=[@Resources]*IF([@[Tracking Type]]="Self-Reported Time",1,60)
8 Replies
Use this formula for Resource Hours:
=[@Resources]*IF([@[Tracking Type]]="Self-Reported Time",1,60)
- HansVogelaar
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?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.
- Boom!! Thank you!!
