ui-only formula fields cannot compare to strings???

Matt SonesMatt Sones ✭✭
edited June 25 in Problems
Here's a simple formula:

IF({{Status__c}}=='Scheduled',true,false)

In runtime, I get the error:
"Invalid syntax for field formula: IF({{Status__c}}=='Scheduled',true,false). ReferenceError: Scheduled is not defined"

Comments

  • Rob HatchRob Hatch 🛠️ 
    edited September 2016
    Here is the syntax I have used to good effect: 

    IF({{StageName}}=="Needs Analysis","Hop To It","Chill")

    I think double quotes are your friend... 
  • Matt SonesMatt Sones ✭✭
    edited February 2017
    No luck:

    Invalid syntax for field formula: IF({{Father_of_the_Baby_Intention__c}}=="Abort",true,false). ReferenceError: Abort is not defined
  • Matt SonesMatt Sones ✭✭
    edited June 25
    ^^bump^^
  • Pat VachonPat Vachon ✭✭
    edited January 2016
    This still an issue for you?

    Briefly had the same issue until I found this post and saw the double equals "==".

    Your formula is using single quotes and I get the same error when using single quotes. Have you switched to double quotes?
  • Matt SonesMatt Sones ✭✭
    edited December 2016
    I believe this was fixed with 7.19
  • DaveDave ✭✭
    edited January 2017
    Hi,

    Anyway to do the same for large text type fields to see if Null?

    IF({{field__c}}== "",0,1)

    When I tried i get the following error: SyntaxError: Unexpected token ILLEGAL

    Thx
  • edited December 2015
    We're trying to generate a UI-only field (checkbox) to indicate if a large text field has contents as well - any tips?
Sign In or Register to comment.