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