Setting:

I have two custom objects

   The master has a field called: "number of completed requests" and "Value of compleated requests"

   The child record has "Value of request" and "status"

I have workflow that:

    When status is changed to "Complete"

       Sends eMail to accounting (WORKING)

       What is not working is "number of completed requests" being incremented by one

          Formula: Account_del__r.Number_of_References__c + 1

       Nor is "Value of compleated requests" being incremented by "Value of request"

            Forumla: Account_del__r.Reward_Balance__c + Reference_Value__c

I get no syntex errors but when this workflow runs it blanks out any existing values in the parent.

any ideas?

i have a trigger on a lead that throwing errors due to validation rules.  Is there a good way around this?  It is painful trying to skirt the validation rules when a trigger fires?

Setting:

I have two custom objects

   The master has a field called: "number of completed requests" and "Value of compleated requests"

   The child record has "Value of request" and "status"

I have workflow that:

    When status is changed to "Complete"

       Sends eMail to accounting (WORKING)

       What is not working is "number of completed requests" being incremented by one

          Formula: Account_del__r.Number_of_References__c + 1

       Nor is "Value of compleated requests" being incremented by "Value of request"

            Forumla: Account_del__r.Reward_Balance__c + Reference_Value__c

I get no syntex errors but when this workflow runs it blanks out any existing values in the parent.

any ideas?

I am a bit of a beginner at formulas, so hopefully one of you will think this is easy, and be able to help. :-)

Customer requirement:

Create a formula field that displays the Week Number (as Week 1, Week 2, etc), based on the Date entered on a particular record (same object).

Ex: 01/01/09 - 01/04/09 would return a value of "Week 1"  

01/05/09 - 01/11/09 = Week 2

01/12/09 - 01/18/09 = Week 3

and so on.....

Is using the CASE function the way to go, and if so, what's the shortest way to create this formula?

Thank you in advance!

S