Questions tagged [formula-field]
A formula field is a field that automatically calculates its value from other fields, expressions, or values.
869
questions
0
votes
1answer
23 views
PT1 profile is not changing as per requirement [closed]
i have created a validation formula to change the default PT1 profile which is displaye on user info section but it is not showing the value as expected can some one help here.
IF(Profile.Name="PT1","...
0
votes
1answer
33 views
Hyperlink Formula field does not work
I have created a custom Formula field for a Travel object and inserted HYPERLINK formula:
HYPERLINK( "https://apps.fas.usda.gov/visa_requirements/index.asp" , "Link to Foreign Agricultural Service ...
0
votes
0answers
13 views
Calculate Arrival date minus Lead Created Date formula
I am looking to add a formula in a lead report that calculates the arrival date (2/8/2019) from the lead. Arrival date minus Lead Created Date
-1
votes
0answers
25 views
Trigger to update the fields in the same object
i am stuck with the following trigger, my Requirement is that, when i create a new lead, the Values which are present in the Formula field, needs to be updated in the normal Custom text field, Now ...
0
votes
1answer
21 views
Outputtext rendered conditional check not working with < or >
This is my VF outputtext which works fine:
<apex:repeat value="{!port.hList}" var="per">
<tr>
<td>
<apex:outputText value="{0, Number, #,###,###.00}" rendered="{!...
0
votes
1answer
39 views
Error: Incorrect parameter type for operator '-'. Expected Number, DateTime, received Date?
I am trying to figure out what I am doing wrong in this Salesforce formula. I am trying to find the MIN between two dates.
IF(
ISBLANK(Fulfillment_Date__c) && ISBLANK(...
0
votes
1answer
12 views
Is there a way to define if a field is Ever Updateable, if Update access can be granted to a field by Profile or Permission Set?
Is there a way to define if a field is Ever Updateable, if Update access can be granted to a field by Profile or Permission Set?
Field Describe information for a field can define if permissions can ...
0
votes
1answer
17 views
Report - Text Field Less Than number
I want to create a report for an object that has a text field 'identity__c'.
The text field is usually in the format of a number and I want to run a report with a filter that will return all records ...
1
vote
0answers
13 views
Is Salesforce Advanced Formula Example for Business Days Incorrect?
Throughout the year we have been using the following formula field from Salesforce Advanced Sample Formula to calculate the number of business days:
This is recommended on the Salesforce Website ...
2
votes
0answers
30 views
Formula field's actual formula
IS there any way to get what a configured formula fields actual formula is?
Strange ask, I know, but we dont use visual force for our front end. We build it ourselves with JS. The issue then is ...
0
votes
0answers
37 views
Formula to get lessor of two date fields before comparing to another third date field?
I am trying to find the lessor of two date fields, then comparing that "lessor" date field to another date field to trigger a checkbox on/off.
Here is the current formula, however, im trying to ...
1
vote
1answer
20 views
Change a formula field and get Data Uniqueness Violation - The proposed data changes would violate a uniqueness constraint
Given
Existing custom field Asset.SerialNumber (OOTB - Text)
New custom field Asset.SerialNumber_bis__c (Text255, External Id non-unique, deterministic encrypted case insensitive)
Existing custom ...
0
votes
2answers
42 views
Wrong decimal formula: I can't get the right value
I use this formula field in my apex code. But I have big troubles with it, because there should be different logic for values 0 and NULL.
If I choose Treat blank fields as blanks, I'll get NULL even ...
0
votes
1answer
30 views
Months between 2 dates [closed]
I am trying to get the number of months between 2 dates(01'Aug 19 and Today).
I am using the below formula, but am geting a syntax error
(((YEAR(TODAY()) - YEAR(2019,08,01) - 1) *12) + (12 - MONTH(...
0
votes
2answers
46 views
Multiple IF Statements for Formula Checkbox
I am new to Salesforce, and am still learning about the formula fields...so please bare with me.
I am looking to create a formula for a new checkbox called Past Due to perform the following functions:...
0
votes
1answer
56 views
Formula Field based on Subscription Start and End Dates in Salesforce Not Responding as Expected
We have a formula field on the Subscription record called "ARR Contribution". The formula is:
Total_Amount__c /
BLANKVALUE(SBQQ__ProrateMultiplier__c,
CEILING((((...
0
votes
0answers
11 views
Lock text information of a formula field while the original field being changed [duplicate]
Is it possible to lock the text information of a cross object formula field after a trigger while the original field is changed later?
enter image description here
e.g.
ABN and GST fields in the ...
1
vote
2answers
33 views
$Profile.Name in Formula field not updating the checkbox
We have a Custom Field (Formula) on User object which has a simple formula to set the checkbox True if the user's profile is System Administrator.
But here i have a user with different profile with ...
0
votes
1answer
32 views
How to display value in formula field using logged in user locale?
Use case,
I want to display value of Invoice Date on Quote Template document based on logged in user locale.
We have date field in Line Columns of CPQ Quote template where we add API Name of date ...
0
votes
0answers
49 views
Custom URL field shows link with _HL_ENCODED_ in front of it
I have a custom URL field that stores a copy of a URL value from a formula(text) field. The formula field uses the HYPERLINK() to generate a link. When I ouput this field in apex it shows with some ...
0
votes
0answers
14 views
How to find out whether there is leap year between a date range? [duplicate]
Could anyone please advise how to find out between a date range if there is leap year or not.
e.g Start Date = 1 Jan 2019 and End Date is 31 Dec 2022
now using formula field or Apex , how to check ...
0
votes
1answer
28 views
formula field to display flag
I am trying to display a green flag when Account status__c(status__c is a picklist field) is Active, else display red flag. I have written below in formula field, but I am getting error message as "...
1
vote
1answer
28 views
I need help with a formula field that's bombing out
I have a field that is a picklist field. Then I have a field that is a formula field that calculates a score based upon the option that is chose from the picklist field. This formula is a Case formula ...
2
votes
0answers
58 views
Formula.recalculateFormulas producing gack
Winter 20 release is in live, so I wanted to use this glorious feature Formula.recalculateFormulas
Thus I tried the below block of code:
Opportunity opp = new Opportunity(Purchase_Price__c=2000 , ...
1
vote
1answer
41 views
Formula field help, please
I have 3 text formula fields: Field 1, Field 2 and Field 3. I want to create Field 4 formula field that checks if there is value in any of those 3 fields and give the value to Field 4.
I have tried:
...
0
votes
1answer
23 views
Different Formula for Different Record Types
I have a custom object that has all the same fields except the value of one depends on the record type. I would imagine I could define a lengthy formula with IF but is there a cleaner way?
Ideally, I ...
0
votes
0answers
23 views
How to fetch whatId label in salesforce formula field [duplicate]
I have requirement where in WhatId should be able to display parent name(label) in formula field, i have tried using what.Name in formula field but it displays an error.
The below code fetches the 15 ...
0
votes
1answer
16 views
ISBLANK Formula Help
I'm trying compare 2 values and then note if the values match or not via a formula.
This is the formula that is working as expected -
Nation__c = Planning_Authority_Nation__c,"Countries Match","...
1
vote
1answer
25 views
Validation Rule not firing after new records is created, only existing
Validation Rule is only working for existing records. When new records are created and edited the VR is not firing.
Multi-Selection picklist, there are 2 choices: Project manager (default) ...
0
votes
2answers
20 views
Creating a Last Activity Date Formula Field
I'm looking to use Last Activity Date for a report that I am creating for my Sales team, but it does not appear to populate correctly. At least not according to what I've read in the literature posted ...
0
votes
0answers
9 views
How to give URL in IF condition while creating List Button
/apex/AP_xxx?oppId={!Opportunity.Id}
This is my URL
IF(ISPICKVAL(Opportunity.Class__c, 'xxx')
This is my condition
How to write URL in if condition in button creation.Kindly help
0
votes
0answers
26 views
Salesforce formula to exclude holidays between two date time fields
I would like to create one formula field on Case object which calculates business hours between two dates. Weekends, as well as Holidays mentioned in Business hours, should be excluded in the formula. ...
0
votes
0answers
23 views
Time based trigger on Formula Date field - what if the date changes on parent
I have a formula field Campaign start date on the child object.
Campaign start date = Campaign__r.StartDate
I have a time-based workflow that fires an email alert 10 days before this Campaign start ...
-3
votes
1answer
30 views
How to apply 3 conditions in formula field?
I am trying apply 3 conditions in formula field. but I'm to complete the requirement. My formula will be like this
IF(
AND(
CreatedById = 'xxxxxx',
ISPICKVAL(Scenario__c ,'Budget'...
-1
votes
2answers
39 views
How to separate Numbers from field data? [closed]
I have a field called Name. The Value of Name field is like 1001PAIO or 100PAJK.
I need to divide the Name field into 3 fields.
One field should have only Numbers I.e first 3 or 4 digits
Second ...
1
vote
1answer
25 views
Error on formula field to add 4.5 years
I have an existing formula field that is displaying an error on the field (#Error!) when the month is June(6). Would someone be able to help in how I should re-write this formula?
IF(MONTH( Date ...
0
votes
1answer
116 views
Reference a Contact field as a value in a Task Process with Process Builder
I need to update 3 fields on Task based on the values from the possible related objects (Lead or Contact) using the standard "Related To" field.
I need to do this without code.
I was thinking of ...
0
votes
1answer
93 views
How to calculate Current quarter and last month of previous quarter in List View?
I need a list view to display List of records of current quarter and last month of previous quarter. I think I need to write a formula field to calculate current quarter and last month of previous ...
0
votes
0answers
22 views
Matrix % Formula to Add Two Columns and Divide by Grand Total
I am looking to create a formula that will calculate % Closed which includes columns Contract Signed and Installation Completed divided by the Grand Total column. Every time I try to identify the ...
0
votes
2answers
47 views
Formula field to calculate difference between years
I have 2 text fields, start year & end year, I want to create a formula field that calculates the difference between these two years entered, and if the end year is current, the formula field ...
0
votes
1answer
29 views
Hyperlink formula to report with multiple field
I want to make a formula with a Hyperlink function in order to display a report in salesforce LEX with pre feel value.
I try to begin with this syntax =>
HYPERLINK("#/sObject/00O58000004Rabl/view?...
0
votes
1answer
31 views
How to write formula field to replace multiple values in the field?
I have a field with the value 1;2;3;4;5;6;7;8
I would like to replace with one;two;three;four;five;six;seven;eight through formula field.
Workaround:
Used Substitute function:
SUBSTITUTE(Name, "1", "...
0
votes
2answers
48 views
Profiles and Image Formula Fields
I had to create a profile that was significantly more restricted than any of our other profiles. In the process of creating this profile, I have ended up causing an important formula field with an ...
-3
votes
2answers
62 views
is there a function that would remove all special characters from a formula field
I want to remove all special characters from a formula field called "ABC". Is there a way I could use one function that could remove all special characters or do I need to specify each special ...
0
votes
0answers
52 views
How to Use Formula Field to Log Out and then Open a URL?
Background
I'm trying to set up a Formula (Text) field with the HYPERLINK function to log a user out of their session and then open an external URL:
HYPERLINK("/secur/logout.jsp?retURL=www.google....
0
votes
0answers
38 views
Help with formula field:
Below formula count 1 when statement is true and count 0 when statement is false.
I am using this formula to calculate bad data populated being populated in lead object.
Output of this formula is ...
2
votes
2answers
28 views
Formula showing Day Of Week and CreatedDate as a Text String
I am trying to create a formula field that will return the Day of the Week concatenated with the date the record was created. The end result should look like this:
Tuesday - 8/13/2019
I have this ...
1
vote
2answers
42 views
Formula Field Check Syntax not working
I am trying to check the syntax of the following formula field but it is not displaying any information. When I try to save, it says there are error and to read the message below. When I scroll down ...
1
vote
1answer
43 views
Case Formula Syntax Error
Any ideas on why this returns Missing ")"? Thanks!
CASE ( Mission_Aligned__c,
"No elements aligned",1,
"Few elements aligned",2,
"Some elements aligned",3,
"Most elements aligned",4,
"All elements ...
0
votes
0answers
24 views
Disable Hyperlink on closing form
I have a formula field with a hyperlink that redirects to a aura component with a form,I wanted to know if there is a way to disable the hyperlink for that record when we close the form or when we ...
