The formula below requires certain picklists to be populated based on dollar values in corresponding fields.  This works for all departments.  I added the red section because I want to filter in two departments that have to obey this validation rule.  When I added the 3 red lines I no longer received error messages when I was supposed to.  I only want Networks and Distribution to have to follow this validation rule.  What am I missing?

Thanks.

AND(
DATEVALUE(CreatedDate) > DATE(2012,8,23),
AND(
ISPICKVAL( CCI_Division_Region__c , "CCI Networks"),
ISPICKVAL( CCI_Division_Region__c , "CCI Distribution"),
OR(
AND(Services__c > 0,
ISBLANK(TEXT(Product__c )),
ISBLANK(Services_Product_Involved__c)),
AND(Support__c > 0,
ISBLANK(Support_Provider__c)),
AND(Product__c > 0,
ISBLANK(TEXT(Product_Manufacturer__c))))))

I'm having a devil of a time getting this formula to work for me.  If anyone can see something obviously wrong I'd appreciate the help.

IF (AND( Total_Days_to_Quote__c > 16, Total_Days_to_Quote__c <= 28), 1,

IF(AND (FLOOR( Total_Days_to_Quote__c / 28 ) > 1 , MOD( Total_Days_to_Quote__c ,28) > 16 ) , (FLOOR( Total_Days_to_Quote__c / 28 ) + 1),

IF(AND( MOD( Total_Days_to_Quote__c , 28) < 16 , FLOOR( Total_Days_to_Quote__c / 28 ) > 1) , FLOOR( Total_Days_to_Quote__c / 28 ) , 0)))

I’m trying to configure a formula field with a series of nested IF statements which each use an AND function.  The business problem briefly is as follows:  A customer get quoted an entire month after the 16th day of a quote period.  I’m trying to determine how many months to quote using the Mod and Floor functions.  So if the customer has the product after the 17 thru 28 day they are quoted for 1 month.  All monthly calculations are based on 28 days.  If they keep the product until the 17 day after the first month they will be quoted for another month for a total of 2 months.  If the customer keeps the product less than 17 days the monthly quoted rate is 0.  I’m using Total_Days_to_Quote as my number of days to base the quote.  My code will compile.  If the condition for the first IF is met the line executes properly.  If any other conditions exist the second and third IF statements don't execute as I think they should and the formula returns 0. 

My formula consists of 3 IF statements and an ending “0”. 

The first IF tests for quote days between 17 & 28 in period 0.

The second IF tests for subsequent contract periods greater than the first period using the FLOOR function (tests for next lowest integer) and the days greater than 16 using the MOD functions (tests for remainder).  .

The second If tests for subsequent contract periods greater than the first period using the FLOOR function and days less than 16 using the MOD functions (tests for remainder) and FLOOR function (tests for next lowest integer).  I can't get this statement to return a value.

Finally if none of the IF conditions are met a 0 is returned.  This is the value is being returned except for IF statement 1.

Thanks for your help in advance,

Ken

Hi,

I am trying to create a Case formula, but only getting "OTHER" for all records.

CASE(  $UserRole.Name  ,
                "BRK Rep", "CORE",            
                "BRX Rep", "CORE",              
                "Bulk", "BULK",
                "Commercial Strategic Accounts", "STRATEGIC",
                "Construction Specialist Rep","CORE",         
                "CT Rep", "CORE",
                "Enterprise Rep", "CORE",
                "LIE Rep","CORE",
                "LIW Rep", "CORE",
                "Manager for Sales Agent", "AGENT",
                "NJC Rep", "CORE",              
                "NJN Rep", "CORE",
                "NJS Rep", "CORE",
                "Power to Learn", "POWER TO LEARN",
                "Power to Learn Sales", "POWER TO LEARN",
                "Power to Learn Sales Agents", "POWER TO LEARN",
                "WC Rep", "CORE",
             "OTHER")

Hi,

I have a requirement on Case Object, where in only a Case Owner must be able to Close,Change Status (or simply Edit) the Cases  for which he is the Owner.

When users other than Case Owner tries changing the Status (picklist field on Case Object) he should be shown an error message saying that he is not the authorised one.

How to achieve this functionality using Validation Rule.

Please provide your inputs.

Thanks in Advance.

Regards,

Sravika

I need to calculate the Age Time of a Record , I have a field Assigned Time to catch the time of the assigned record.

so i have writtened Formulae Field  to calculate the Age Time of a record is

Age_Time = Assigned_Time__c  -  Createddate            

it is fine, but i should need to exclude saturday , sundays from this Age Time. means if it is 7 days then we dont include saturday , sunday (48 hours) ,


other wise it should be normal calculation. For ex, if record is created Tuesday  and assigned on Thursday then there is no need of excluding saturday, sunday hours (48).

Hi, 

I have a requirement where I have to create a Custom button and place it on case detail Standard page layout but I have to make it visible only if a Value in Status field in case is ="Required" and should not come on case detail page if the status value is other than "Required". 

I am stuck with this, any help is highly appriciated.

thanks & Regards,

Hi All,

 I need a report  based on Case. I need to calculate the time duration when the case is in "R&D" and "in Progress" status.

 However this report should show the time duration according to the representative.

e.g.  there is a case 1 

1. User1 change the status from NEW to IN PROGRESS. say at 9am

2. User 2 change the satus from IN PROGRESS to HOLD Say at 10am

3. User3 change the status from HOLD to R&D say at 12 pm

4. USer4 change the status from R&D to closed say at 15 pm

Hence i need report as

User 1 ::  Working hours 1(10am-9am) IN PROGRESS

User2  :: Working hours  3 (15pm -12pm) R&D

Any help and suggestion is highly appreciable.

Thanks,

Mayank

The formula below requires certain picklists to be populated based on dollar values in corresponding fields.  This works for all departments.  I added the red section because I want to filter in two departments that have to obey this validation rule.  When I added the 3 red lines I no longer received error messages when I was supposed to.  I only want Networks and Distribution to have to follow this validation rule.  What am I missing?

Thanks.

AND(
DATEVALUE(CreatedDate) > DATE(2012,8,23),
AND(
ISPICKVAL( CCI_Division_Region__c , "CCI Networks"),
ISPICKVAL( CCI_Division_Region__c , "CCI Distribution"),
OR(
AND(Services__c > 0,
ISBLANK(TEXT(Product__c )),
ISBLANK(Services_Product_Involved__c)),
AND(Support__c > 0,
ISBLANK(Support_Provider__c)),
AND(Product__c > 0,
ISBLANK(TEXT(Product_Manufacturer__c))))))

Hi all,
I am having two custom objects which is named as custom_object1__c,custom_object2__c.I want to write the validation rule on custom_object1__c saying that "custom_object1__c.transactiondate should be always greater than custom_object2__c.somedate".

I have written the validation rule like this.
transactiondate__c < custom_object2__c.somedate__c

I am getting the following error.
Error: Syntax error. Found 'custom_object2__c'

how can i write the rule for this scenario.
please help me to solve this.

thanks,
Arun.

Can the following logic be implemented – For each EXTERNAL_ID, if STATUS field is populated with value ‘T’ AND field ‘TERM_DATE’ does not equal ‘{PREVIOUS DAY’S DATE}’ exclude the record from the daily load.

I'm having a devil of a time getting this formula to work for me.  If anyone can see something obviously wrong I'd appreciate the help.

IF (AND( Total_Days_to_Quote__c > 16, Total_Days_to_Quote__c <= 28), 1,

IF(AND (FLOOR( Total_Days_to_Quote__c / 28 ) > 1 , MOD( Total_Days_to_Quote__c ,28) > 16 ) , (FLOOR( Total_Days_to_Quote__c / 28 ) + 1),

IF(AND( MOD( Total_Days_to_Quote__c , 28) < 16 , FLOOR( Total_Days_to_Quote__c / 28 ) > 1) , FLOOR( Total_Days_to_Quote__c / 28 ) , 0)))

I’m trying to configure a formula field with a series of nested IF statements which each use an AND function.  The business problem briefly is as follows:  A customer get quoted an entire month after the 16th day of a quote period.  I’m trying to determine how many months to quote using the Mod and Floor functions.  So if the customer has the product after the 17 thru 28 day they are quoted for 1 month.  All monthly calculations are based on 28 days.  If they keep the product until the 17 day after the first month they will be quoted for another month for a total of 2 months.  If the customer keeps the product less than 17 days the monthly quoted rate is 0.  I’m using Total_Days_to_Quote as my number of days to base the quote.  My code will compile.  If the condition for the first IF is met the line executes properly.  If any other conditions exist the second and third IF statements don't execute as I think they should and the formula returns 0. 

My formula consists of 3 IF statements and an ending “0”. 

The first IF tests for quote days between 17 & 28 in period 0.

The second IF tests for subsequent contract periods greater than the first period using the FLOOR function (tests for next lowest integer) and the days greater than 16 using the MOD functions (tests for remainder).  .

The second If tests for subsequent contract periods greater than the first period using the FLOOR function and days less than 16 using the MOD functions (tests for remainder) and FLOOR function (tests for next lowest integer).  I can't get this statement to return a value.

Finally if none of the IF conditions are met a 0 is returned.  This is the value is being returned except for IF statement 1.

Thanks for your help in advance,

Ken

I have a Master Detail relationship between Opportunities and a custom object.  The Opportunity record has a Summary Formula that uses the custom object.  We also have a Validation Rule on the Opportunity object.  Is there a way to construct the Validation Rule to skip if a custom object record is updated.  According the documentation, the Validation Rule fires when the Summary Formula is recalculated, is there way to skip this?

Hi,

I am trying to create a Case formula, but only getting "OTHER" for all records.

CASE(  $UserRole.Name  ,
                "BRK Rep", "CORE",            
                "BRX Rep", "CORE",              
                "Bulk", "BULK",
                "Commercial Strategic Accounts", "STRATEGIC",
                "Construction Specialist Rep","CORE",         
                "CT Rep", "CORE",
                "Enterprise Rep", "CORE",
                "LIE Rep","CORE",
                "LIW Rep", "CORE",
                "Manager for Sales Agent", "AGENT",
                "NJC Rep", "CORE",              
                "NJN Rep", "CORE",
                "NJS Rep", "CORE",
                "Power to Learn", "POWER TO LEARN",
                "Power to Learn Sales", "POWER TO LEARN",
                "Power to Learn Sales Agents", "POWER TO LEARN",
                "WC Rep", "CORE",
             "OTHER")

Hi Team,

Below Statement is not working for me.

Any Comments on the below statement:

Time-dependent actions remain in the workflow queue only as long as the workflow rule criteria are still valid. If a record no longer matches the rule criteria, Salesforce removes the time-dependent actions queued for that record.

Thanks,

Anil

Hi,

I have a requirement on Case Object, where in only a Case Owner must be able to Close,Change Status (or simply Edit) the Cases  for which he is the Owner.

When users other than Case Owner tries changing the Status (picklist field on Case Object) he should be shown an error message saying that he is not the authorised one.

How to achieve this functionality using Validation Rule.

Please provide your inputs.

Thanks in Advance.

Regards,

Sravika

I  need to write a formula to copy text up to the first "." from one field (Description) to another field. The formula that I have written is not working (see below). I am using a field update to copy the text into another field but the formula is not copying the text up to the first "."

IF( 
OR(FIND(".", Description) = LEN(Description), 
FIND(". ", Description) = 0), 
Description, 
LEFT(Description, FIND(". ", Description)) 
)