I'm trying to use a conditional statement in a salesforce email text template, field is a check box and i want the output in the email template to be yes or no. I'm using the below but it is not working
Catchment Waiver Required: {!IF("{Opportunity.Catchment_Waiver_Required__c}" =="0","No","Yes")}
the output is always yes despite checkbox being ticked or unticked :(
I have also tried the below {!IF(Opportunity.Catchment_Waiver_Required__c =="0","No","Yes")}
which produces nothing
Any help would be greatly appreciated!