Skip to main content Stream TDX Bengaluru on Salesforce+. Start learning the critical skills you need to build and deploy trusted autonomous agents with Agentforce. Register for free.
Topics#Reports & DashboardsPergunta de Matt Palmer
Matt Palmer (Comcast) perguntou em #Reports & Dashboards
10 de jun. de 2021, 20:18

Warning Error when encoding row-level formula: Syntax error. Missing ')'

My end result is to write "Priority" if the conditions are met. I may receiving a syntax error when validating the formula. 

 

Warning: Warning Error when encoding row-level formula: Syntax error. Missing ')'

 

Formula Output Type is set to Text. 

 

Can someone please tell me what I am missing?

IF(
    AND(
        Job__c.Construction_Start_Date__c = " ",
        Job__c.Construction_Milestone_Complete_Date__c = " "),
         'Priority', 
         IF(
             AND(
                 Job__c.Construction_Start_Date__c <> " ",
                 Job__c.Construction_Milestone_Complete_Date__c = " ")
                 'Priority'," " )
                 )

 

 
7 respostas
  1. Steve Molis (You Owe Me a Beer, Inc.)
    10 de jun. de 2021, 20:48

    When you're done washing the blood off your hands, try this

    IF(
        AND(
            ISBLANK(Job__c.Construction_Start_Date__c),
            ISBLANK(Job__c.Construction_Milestone_Complete_Date__c)
    		),
             'Priority', 
             IF(
                 AND(
                     NOT(ISBLANK(Job__c.Construction_Start_Date__c)),
                     ISBLANK(Job__c.Construction_Milestone_Complete_Date__c)
    				 ),
                     'Priority', 
    NULL) )

     

     
  4. Matt Palmer (Comcast)
    10 de jun. de 2021, 21:13
    Hi Steve,

     

    It looks like that work. Thank you for the help! I'll keep the Baby Seals in mind next time. 

     

    Thanks,

     

    Matt

     

     
  5. Steve Molis (You Owe Me a Beer, Inc.)
    10 de jun. de 2021, 20:45
    Just an fyi , this  Job__c.Construction_Start_Date__c = " " <== is not saying   "ob__c.Construction_Start_Date__c field is blank, or null, or empty".  

     

    That is litrerally saying   "Job__c.Construction_Start_Date__c field has a single space character in it. Also, it kills a baby seal.... 

     

    Just an fyi , this Job__c.Construction_Start_Date__c =
  6. Matt Palmer (Comcast)
    10 de jun. de 2021, 20:32
    Hi Keiji, 

     

    Thank you for your response. I just tried your formula and now I am receiving a different error. 

     

    Error message: Error when encoding row-level formula: Incorrect parameter type for operator '='. Expected

     

    DateTime, received Text

     

    Again here is the formula I used:

    IF(
        AND(
            Job__c.Construction_Start_Date__c = " ",
            Job__c.Construction_Milestone_Complete_Date__c = " "),
             'Priority', 
             IF(
                 AND(
                     Job__c.Construction_Start_Date__c <> " ",
                     Job__c.Construction_Milestone_Complete_Date__c = " ")
                     'Priority'," " )
                     )

     

    Hi Keiji, Thank you for your response. I just tried your formula and now I am receiving a different error.

     

     
  7. Keiji Otsubo (Fukada Electric Co.,Ltd.)
    10 de jun. de 2021, 20:22
    Hi Matt,

     

    Try this

     

    IF(
        AND(
            Job__c.Construction_Start_Date__c = " ",
            Job__c.Construction_Milestone_Complete_Date__c = " "),
             'Priority', 
             IF(
                 AND(
                     Job__c.Construction_Start_Date__c <> " ",
                     Job__c.Construction_Milestone_Complete_Date__c = " "),
                     'Priority'," " )
              )

     

    Job__c.Construction_Milestone_Complete_Date__c = " "), <---  add ,
Escrever uma resposta...
0/9000