I am trying to create a workflow rule for Cases that triggers when the Status changes but only if the Case Origin equals a specific value.

I have tried to figure out the formula myself but have hit a brickwall - any help from the community is greatly appreciated.

We currently send out emails to Case Contacts to let them know the case number assigned to them.  We use this with Email Alerts using an email template (more professional looking).  Problem is, the cases are assigned to a queue and we would like the email to show that it is from our generic service email address rather than the email address from the Case "Creator".

Anyone have any ideas on how this may be done?

I am trying to create a workflow rule for Cases that triggers when the Status changes but only if the Case Origin equals a specific value.

I have tried to figure out the formula myself but have hit a brickwall - any help from the community is greatly appreciated.

I am trying to create a validation rule that will require users to select a value from the picklist "Revenue Type" whenever the opportunity stage changes to "Bell". I am having trouble making this work correctly. Here is my current attempt at a validation rule:

AND( ISPICKVAL( StageName, "Bell"),   ISPICKVAL( Revenue_Type__c, "0"))

(but this doesn't seem to work since I can still change an opportunity to the "Bell" stage without having to select a Revenue type before saving).

Any help would be much appreciated!!

Is  there a sure set way to verify whether a lookup field is empty? 

Thanks for any help.

My question is what formula I needed to enter into the custom field calculation section so that I can have a field calculating at a different rate for a different salesforce user or case owner.

E.g. My rate is $130 per hour but another consultant’s rate is $140 per hour. I do not wish to setup to different fields to accommodate this as it will make modifying my existing reports a nightmare!

The current calculation as it stands works for everyone (All case owners) and it calculates at 130.00

This is the code:

Total_Time_Normal__c * 130.00

This is the custom codes already setup so we can enter our hours worked on a case which automatically calculates the chargeout to the client:

This is what it looks like in a case:

Description Information:

Additional Information:

Any assistance would be greatly appreciated. Thank you.

Chris

Hello,

Is there a way to automatically assign an account by territory? (That is, if Territory = Los Angeles, then owner = Mary, else if Territory = San Francisco, then owner = John.)