I am drafting a formula and received "Formula Help - Error: Incorrect parameter type for function 'IF()'. Expected Boolean, received Number"? - Answers - Salesforce Trailblazer Community
  • Log In

Browse by categories

Ask Search:
ShowAll Questionssorted byDate Posted
Ryan RussikoffRyan Russikoff 

I am drafting a formula and received "Formula Help - Error: Incorrect parameter type for function 'IF()'. Expected Boolean, received Number"?

IF((MIN( Days_since_last_contacted__c , Days_since_last_contacted_Pardot__c )),  0,Days_since_last_contacted__c)

The min formula I have is choosing the 0 but if it one of the #s is zero I want to revert to the other number.
Best Answer chosen by Ryan Russikoff
Pruthvi RajPruthvi Raj
@Ryan: Try this 
IF(
	(Days_since_last_contacted__c < Days_since_last_contacted_Pardot__c ),
	0,
	Days_since_last_contacted__c
)

All Answers

Pruthvi RajPruthvi Raj
@Ryan: Try this 
IF(
	(Days_since_last_contacted__c < Days_since_last_contacted_Pardot__c ),
	0,
	Days_since_last_contacted__c
)
This was selected as the best answer
Ryan RussikoffRyan Russikoff
Thanks @pruthviraj - just for learning- what exactly does this one say?
Pruthvi RajPruthvi Raj
@Ryan: Always Welcome !!!
Generally IF conditions syntax is : IF ( Condition , value if true, value if false).
So here in the place of condition you should give something which evaluates and gives you either true or false based on which the values will be taken. In your formula you wrote MIN( Days_since_last_contacted__c , Days_since_last_contacted_Pardot__c )
It gives whichever field is minimum, let's last_contacted_pardot is less then it will give last_contacted_pardot's value which will be a number. But here it should have been a condition. That's what I replaced it with.