New answers tagged

0

The expression which you have written will only evaluate to true if values will exactly match with Company name. According to your requirement you should try this: CONTAINS(Compoany, "HP") || CONTAINS(Compoany, "H-P") || CONTAINS(Compoany, "NA.Co")


1

Unfortunately, formulas aren't tailored for this. You'll need an Apex trigger.


0

So you're looking to return a single value and stop processing on the first blank field. To do that, you'd want to chain all of those IF() together instead of completing each one and adding 0 in the "else" case. IF(ISBLANK(Desired_Limit__c), 2, IF(ISBLANK(Current_CC_Spend_in_EUR__c), 3, IF(ISBLANK(TEXT(...


-1

First Solution First Calculate Minutes between two dates. Then convert hours and minutes . using formula field Calculate Minutes Formula ( Second_Date__c - Frist_Date__C )*24*60 Convert Minutes in Hours TEXT(FLOOR( Duration__c / 60)) &' Hours '& TEXT(MOD( ...


1

ISPICKVAL(Reason_for_OF_referral__c, "Parallel Process"), I don't think that comma should be there at the end as it's the last parameter you're providing to your AND operator.


1

Actually I don't think. You need Workflow rule for this. Hope you can get Customer_Budget__c and Unit Price values via manually. So Please use formula function to achieve this, For Quantity field formula will be, Customer Budget / Unit Price For Total field formula will be, Quantity * Unit Price For Remainder Amount field formula will be, ...


1

I would solve it with a date field (to record the last changed date), a number formula field (to calculate the number of days since the change), and a workflow rule to set the date. For example, to monitor the opportunity stage field, you might do the following: Field To Monitor: StageName Date Field: Stage_Last_Changed_Date__c Number Formula Field: ...


Top 50 recent answers are included