Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
HNT_NeoHNT_Neo 

Formula field to update a checkbox

I have a percentage field box with an API name field of BG_CHBX_06__c, and I want to create a separate checkbox to default to TRUE if the percent is greater than 75%. 

Can someone help me with the correct syntax? 

Thank you!

API Field Name             Field Type    
BG_CHBX_06__c              Percent
BG_CHBX_06_VALUE__c        Checbox

 
Best Answer chosen by HNT_Neo
Sitarama MurthySitarama Murthy
hi Neo,

Create BG_CHBX_06_VALUE__c field has formula field, return type is checkbox.
after that use this formula,

IF(BG_CHBX_06__c > 0.75,True,false)

thanks

All Answers

Sitarama MurthySitarama Murthy
hi Neo,

Create BG_CHBX_06_VALUE__c field has formula field, return type is checkbox.
after that use this formula,

IF(BG_CHBX_06__c > 0.75,True,false)

thanks
This was selected as the best answer
HNT_NeoHNT_Neo
Thank You! This worked perfectly!