New answers tagged

2 votes
Accepted

Calculate the number of quarters two dates span across

From the excel docs: YEARFRAC will return the number of days between two dates as a year fraction, in decimal form If you substract 2 dates in Salesforce formulas, it will give you the number of ...
Guy Clairbois's user avatar
1 vote
Accepted

Nesting Formulas In A Flow

Formulas are evaluated when they are used. To test this, I set up two number variables: Number1 Number2 Then I created a formula: Name: Number1Value Type: Number Formula: {!Number1} I then used ...
sfdcfox's user avatar
  • 490k
0 votes
Accepted

Flow formula calculating incorrectly

Contrary to your claim, you haven't used parenthesis to indicate order of operations. The parens begin and end with each individual BLANKVALUE(), and there are no other parens, so your formula is 1 - ...
Derek F's user avatar
  • 61.5k
2 votes
Accepted

IF statement in HTML Template Giving blank output

Classic templates (text, HTML, custom) do not support formulas. They're specifically called "merge fields" for a reason. Instead, use a Visualforce template, which does support formulas. ...
sfdcfox's user avatar
  • 490k
1 vote
Accepted

Gack error when formula in entry condition of a record-triggered flow references null value of a custom picklist field

This seem to be a bug with salesforce. Kindly review KI details and try below workaround. Keep this entry criteria formula into a formula resource and use a decision element as the first element in ...
Vinay's user avatar
  • 3,450
0 votes

Referencing Setup Custom Settings Fields in Salesforce CPQ Quote Terms

I believe the only Objects which can be referenced on the standard HTML or Line Item Quote Term types are the following: Quote Template Quote Primary Contact (Contact field on Quote - so specific ...
cloudcap's user avatar
  • 187

Top 50 recent answers are included