Checkbox value in a UI only formula

  • 1
  • Question
  • Updated 2 years ago
  • Answered
This should be an easy one. I have a salesforce checkbox..... let's call it Checkbox__c. I have a UI only formula field that I want to return the value of that checkbox so I can use in an if statement. However, {{Checkbox__c}} isn't returning anything. I think it should be. The box that would be in context is checked, so I would expect it to return true. I'm able to get the values of other fields, just not this Boolean. Any thoughts? I tried wrapping it in VALUE(), but that didn't help either.
Thanks
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb

Posted 2 years ago

  • 1
Photo of Janick

Janick

  • 916 Points 500 badge 2x thumb
Hey Raymond,

Are you trying to do this in a formula field? If so, try using this in a formula field with the return type "text":

IF({{Checkbox__c}},value_if_true,value_if_false)

Hope this does the trick,

Janick
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb
Yes, a formula field. I'll give it a try. Thanks.