Hi,

I am having a requirement for which i need help

I am having a picklist field called as "Type" and a dependent picklist called "Subtype"

If i select the value of the field "type" to a specific value and subtype to a specific value , 

I have another currency field "Smartauction_Amount_of_Current_Exception__c" which should not be blank on saving the record


So i have written a valdiation rule below as follows,

IF
(
AND
(
NOT(ISBLANK(SmartAuction_Number_of_Contracts__c)),
ISBLANK(Smartauction_Amount_of_Current_Exception__c)

), true, false
)


Its working fine , but another requirement is

Even if the value is "0"  for the field "Smartauction_Amount_of_Current_Exception__c"  also it should not save it should have a valid number apart from "0" 


Help me how to achieve this 

Thanks in Advance

Hi
i have a text field separate by semicolon, for example

word1;word2;word3;word4;word5

and i want a custom formula field for each word, for example

field A  populated by word1
field B  populated by word2
field C  populated by word3
field D  populated by word4
field E  populated by word5

i have these formula, but only works with one semicolon
LEFT(textfield__c, (FIND(",", textfield__c)-1))

RIGHT(textfield__c, (LEN(textfield__c) – FIND(",", textfield__c)))


Thanks for your help

I am trying to get a field to set a date time when a field is changed however there are conditions where i need that field to be empty when the field has a null or NO value is there an easy way to set a cleared date field using a workflow or the conditional formula field

in the code below the dp.CS_LocationsCSV__c is comma selerated string of account numbers  ie  123,145,16,143  and i need to use them in the soql querey  SELECT Account__r.id ,source_key__c  FROM ERP_Data__c where source_key__c = :csv   this works fine with one account number but i may have up to 50, how can i get them into a useable set for the querey?

trigger CS_links on Distributor_Program__c (after update) {

   if(checkRecursive.runOnce())
    {

// get a list of all Distributor_Program__c to evaluate

Set<String> csv = new Set<String>();
Set<Id> changedcsv = new Set<Id>();

for (Distributor_Program__c  dp :trigger.new){

    String oldcsv = Trigger.oldMap.get(dp.Id).CS_LocationsCSV__c;
    String newcsv = dp.CS_LocationsCSV__c;

    if (oldcsv != newcsv){
    changedcsv.add(dp.id);
    csv.add(dp.CS_LocationsCSV__c);
    }

}
// delete all exsiting Participating_Branch_Locations__c if CS_LocationsCSV__c has changed

list <Participating_Branch_Locations__c> pb = [select id from Participating_Branch_Locations__c where Distributor_Program__c in :changedcsv];
delete pb;

// find the accounts to link to the Distributor_Program__c where the CS_LocationsCSV__c has changed

map<string , account> accids = new map<string , account> ();

list<ERP_Data__c> erps = [SELECT Account__r.id ,source_key__c  FROM ERP_Data__c where source_key__c = :csv];  // todo use the csv string 

for (ERP_Data__c erp :erps){
    accids.put(erp.source_key__c  , erp.Account__r );
     }

//create the Participating_Branch_Locations__c and link to the account and Distributor_Program__c 


list<Participating_Branch_Locations__c> npb = new list<Participating_Branch_Locations__c> ();
        for (Distributor_Program__c  dp :trigger.new){

        account a = accids.get(dp.CS_LocationsCSV__c);
            if (a != null){
            
           
                for (erp_data__c acc : erps) {
                Participating_Branch_Locations__c apbl = new Participating_Branch_Locations__c();
                apbl.Account__c = a.id;
                apbl.Distributor_Program__c = dp.id;
                apbl.key_id__c = a.id + '' +  dp.id ;
                npb.add(apbl);
                }

            }
        }
        insert npb;
        }
}

All,
I hit a character limit in a formula field due to too many IF statements. Therefore I changed it to a CASE statement, but I still have 16 conditionals within the formula that need to return a different accounting number depening on the Product the user chooses. Is it possible to have an AND function within a CASE function?

CASE({!Category__c},
'Advisory Council - Non-sales', '800-114',
'Advisory Council - Sales', '800-113',
'Advisor forum travel - Non-sales', '800-111',
'Advisor forum travel - Sales', '800-112',
'Advisor Road Show', '800-119',
'Advisor Road Show - travel', '800-119',
'Airfare - Non-sales', '800-003',
'Business Meals and Entertainment - Non-sales', '800-003',
'Car Service / Taxi - Non-sales', '800-003',
'Charitable Contributions', '900-800',
'Conference travel - Non-sales', '800-003',
'Copying and Printing', '700-590',
'Courier Services', '700-620',
'Due Diligence', '850-971',
'Employee Meetings', '800-195',
'Gifts - sales', '900-910',
'Gifts - non-sales', '900-910',
'Industry conferences - non-sales', '700-585',
'Internet', '700-637',
'IT Services', '700-575',
'Lodging - Non-sales', '800-003',
'Marketing', '700-579',
'Membership Dues', '700-580',
'Mileage - Non-sales', '800-003',
'Misc. Travel Expenses - Non-sales', '800-003',
'NRS Sales Meetings', '800-004',
'NRS Sales Meetings travel - Non-sales', '800-004',
'NRS Sales Meetings travel - Sales', '800-004',
'Office Maintenance and Repairs', '700-495',
'Office Supplies', '700-540',
'Personal Charges', '900-900',
'Personal Meals', '800-120',
'Phone', '700-639',
'Postage', '700-620',
'Promotional items - sales', '900-705',
'Promotional items - non-sales', '900-705',
'Publications', '700-580',
'Registration Costs', '850-500',
'Managed Company OPEX', '120-515',
'Managed Company O&O', '120-513',
'Managed Company direct investment expense', '120-160',
'Computer Supplies', '700-560',
'Computer Software', '700-570',
'Computer Support', '700-575',
'Airfare - Sales' && TEXT(Product__c) = 'NS HI', '800-001',
'Airfare - Sales' && TEXT(Product__c) = 'NS II', '800-002',
'Business Meals and Entertainment - Sales' && TEXT(Product__c) = 'NS HI', '800-001',
'Business Meals and Entertainment - Sales' && TEXT(Product__c) = 'NS II', '800-002',
'Car Service / Taxi - Sales' && TEXT(Product__c) = 'NS HI', '800-001',
'Car Service / Taxi - Sales' && TEXT(Product__c) = 'NS II', '800-002',
'Conference travel - Sales' && TEXT(Product__c) = 'NS HI', '800-001',
'Conference travel - Sales' && TEXT(Product__c) = 'NS II', '800-002',
'Hosted events' && TEXT(Product__c) = 'NS HI', '800-191',
'Hosted events' && TEXT(Product__c) = 'NS II', '800-192',
'Lodging - Sales' && TEXT(Product__c) = 'NS HI', '800-001',
'Lodging - Sales' && TEXT(Product__c) = 'NS II', '800-002',
'Mileage - Sales' && TEXT(Product__c) = 'NS HI', '800-001',
'Mileage - Sales' &&TEXT(Product__c) = 'NS II', '800-002',
'Misc. Travel Expenses - Sales' && TEXT(Product__c) = 'NS HI', '800-001',
'Misc. Travel Expenses - Sales' && TEXT(Product__c) = 'NS II', '800-002',
null
)

I am facing problem to login into salesforce.com org.

I forgot my password & my email id is not working now.

Please help me to login into my Salesforce org.

My Details are given below:

    URL: https://login.salesoforce.com

    UserName: AnshulKapoor@syntelinc.com
    Email: Anshul_Kapoor@syntelinc.com (not working)

Hi,

I am having a requirement for which i need help

I am having a picklist field called as "Type" and a dependent picklist called "Subtype"

If i select the value of the field "type" to a specific value and subtype to a specific value , 

I have another currency field "Smartauction_Amount_of_Current_Exception__c" which should not be blank on saving the record


So i have written a valdiation rule below as follows,

IF
(
AND
(
NOT(ISBLANK(SmartAuction_Number_of_Contracts__c)),
ISBLANK(Smartauction_Amount_of_Current_Exception__c)

), true, false
)


Its working fine , but another requirement is

Even if the value is "0"  for the field "Smartauction_Amount_of_Current_Exception__c"  also it should not save it should have a valid number apart from "0" 


Help me how to achieve this 

Thanks in Advance

Hi there,

First time post here, I am hoping to find a solution to my problem from one of you talented developers! I recently implemented an opportunity validation rule which requires users to update the 'close date' field anytime the opportunity 'stage' is set to either Awarded/WIP/Lost/Cancelled, this is all that I want to happen. However, users are recieving the 'update close date' error message anytime they update any field while the 'stage' is set to Awarded/WIP/Lost/Cancelled (due to the limitations of the validation rule). I have tried to resolve this issue with Premier Success to no avail, they suggested that this issue can only be resolved via code development. Which brings me here.

Has anyone encountered this before, I appreciate any feedback.

Cheers,

Scott 

I'm working in Visual Workflow. I'm trying to generate a date via formula using an if function. My 'then' and 'else' statements are virtually the same, varying only by adding one month to a calculated date.

However, when my formula returns true on my 'if' statement, the 'then' statement gives me the correct date. When my formula fails my 'if' statement, the 'else' statement is blank.

Here is my formula:

IF(
{!NextPaymentDue}-{!SelectedCharge}<=0,

DATE(YEAR({!NextDueDate}),MONTH({!NextDueDate})+({!Days}/30)+1,DAY({!NextDueDate})+MOD({!Days},30)),
DATE(YEAR({!NextDueDate}),MONTH({!NextDueDate})+({!Days}/30),DAY({!NextDueDate})+MOD({!Days},30))
)

Successfully generates a date of 11/1/2014 when:
nextPaymentDue= 100
SelectedCharge = 150
Days=30
Next Due Date = 9/1/2014

Returns null when:
nextPaymentDue= 300
SelectedCharge = 150
Days=30
Next Due Date = 9/1/2014

Any ideas?

Hi
i have a text field separate by semicolon, for example

word1;word2;word3;word4;word5

and i want a custom formula field for each word, for example

field A  populated by word1
field B  populated by word2
field C  populated by word3
field D  populated by word4
field E  populated by word5

i have these formula, but only works with one semicolon
LEFT(textfield__c, (FIND(",", textfield__c)-1))

RIGHT(textfield__c, (LEN(textfield__c) – FIND(",", textfield__c)))


Thanks for your help

AND(PRIORVALUE( pi__score__c )< pi__score__c - 25, Lead_Record_Type_Text__c = "School Lead", OR(LastActivityDate < TODAY() +5, LastActivityDate=null) )

Can someone help me with this formula. It worked until I added the syntax ' , OR(LastActivityDate > TODAY() +5, LastActivityDate=null)'. I'm trying to say the last activity date has to be greater than today+ 5 days OR equal to blank.
 

Thanks for the help!

Hi,

I'm trying to create a checkbox formula based on if a text field on the record is a previous month and if so set the box to true.
The text field is ImportDate__c (YYYY-MM) and the checkbox is IsPreviousMonth__c

IF
(
MONTH(TODAY()) = 1,
DATE(YEAR(TODAY())-1,12,1) = 
DATE(VALUE(MID(ImportDate__c,0,4)),VALUE(MID(ImportDate__c,5,2)),1),
DATE(YEAR(TODAY()),MONTH(TODAY())-1,1) = 
DATE(VALUE(MID(ImportDate__c,0,4)),VALUE(MID(ImportDate__c,5,2)),1)
)

I'm currently receiving an #Error! in the checkbox on the record.
The record I'm using to test currently has 2013-01 in the ImportDate__c field, so I was expecting the checkbox to be blank.  

Any help is greatly appreciated.

I am trying to get a field to set a date time when a field is changed however there are conditions where i need that field to be empty when the field has a null or NO value is there an easy way to set a cleared date field using a workflow or the conditional formula field

I have two fields :

 

Exposed_date__c (DateTime)

Approved_Date__c (Date)

 

Can i create a formula to get the difference of the two dates in GMT and only business days?

 

I know how to do this programatically but wondering if this can be achieved in a formula.

 

Thanks in advance for your help.