UI only formula field issue

  • 1
  • Question
  • Updated 2 years ago
I'm trying to create a formula field to return "Yes" or "No" to use in a button to set a picklist value based on another field value. Does anyone see any glaring issues with this formula?

IF(CONTAINS({{Fee_Structure__c}},"Billed"),"Yes","No")
Photo of Ashley Erhart

Ashley Erhart

  • 160 Points 100 badge 2x thumb

Posted 2 years ago

  • 1
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb
Not sure how "contains" works in the UI only formulas. You may want to try {{Fee_Structure__c}}="Billed"
Photo of Richard

Richard

  • 394 Points 250 badge 2x thumb
Ashley that formula looks fine, you're using the CONTAINS correctly. It is a case-sensitive function however, could that be the issue? Alternatively it may just be an issue with your process, can you shed any additional light on what your current action framework is?
Photo of Zach McElrath

Zach McElrath, Employee

  • 49,262 Points 20k badge 2x thumb
The Formula looks good --- what behavior are you experiencing when this is used?