New answers tagged formula-field
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