New answers tagged formula-field
0
Some how achieved this by first separate the minutes after . by MID function. So in my case it will be 83. After that Multiply by 60 and divide by 10000 and ie,
83*60/10000 which will give output as .498 and rounding it by 2 will give 0.50
after that LEFT(2.83,FIND(".",2.83)-1) will give 2
So finally 2 + 0.50 = 2.50
0
I can't answer your question directly ("working-as-designed"?) but can suggest a workaround
Create a new Text field on User: Default Currency Code Proxy
Populate this field in a Flow on every change in value to User.DefaultCurrencyCode
Reference the proxy field in your formulas on the relevant objects via the Owner:User polymorphic relationship
0
This formula could have been written as:
BLANKVALUE(Actual_Finish_Date__c, Deadline__c) -
BLANKVALUE(Actual_Start_Date__c, Kickoff__c) + 1
This should make it easier to understand. We want to calculate the number of days between two dates. We'll take either the Actual Finish Date or the Deadline (if no Finish Date is provided), and subtract the Actual ...
1
Formula Operators and Functions
IF(logical_test, value_if_true, value_if_false)
Determines if expressions are true or false. Returns a given value if true and another value if false
ISBLANK(expression)
Determines if an expression has a value and returns TRUE if it does not. If it contains a value, this function returns FALSE.
Assuming that Deadline__c, ...
-3
(TODAY() - DATE OF JOIN)/365. .
1
Parent to child relationships are one-to-many (1-M) and cannot be referenced in a formula field. Your requirement is not clear as to what should happen when there is more than one Offer for a single Opportunity, but generally, you would use a Rollup Summary to get some aggregate such as earliest (first) or latest (last) date, then use that rolled up value in ...
0
This expression in formula will work in the condition and data points provided in query,
LEFT(TextArea__c, FIND('.com', TextArea__c, 0)+3)
2
As a general rule, indenting formulas like you would if they were code (which I've done for you in your question) really reduces the cognitive load (i.e. makes it easier to read/understand). That's helpful when you're trying to debug things.
The first example you gave looks like it was pretty close (if you are using it as the formula for a field update ...
1
You want INCLUDES...
IF(INCLUDES(Job__c, "Doctor") ,
IF(INCLUDES(States__c, "NewYork"), false, true)
, false)
Helpful?!
Top 50 recent answers are included