Skip to main content
Topics#FormulasLEAH Gus's Question
LEAH Gus (Gus) asked in #Formulas
Jun 27, 2022, 1:17 PM

Formula help

I keep getting an error that says Im missing a ) in this formula. 

Not sure where Im Missing a )

Can someone help me?

 

AND( 

[Opportunity].Account.Parent.Name  = 'MAN Group', 

[Opportunity].RecordTypeId != 0121Q000000P0L8QAK, 

TEXT([Opportunity].Lease_Admin_Fee__c) = '150', 

[Opportunity].Lease_Expiration_Month__c  <=  6, [Opportunity].Holdover_Rent_Percentage_Increase__c =0.20, [Opportunity].Rent_Percentage_Increase__c =0.04, ISPICKVAL([Opportunity].Approved__c , '')),  

 

OR(   [Opportunity].Prorated_Move_In_Date__c <  [Opportunity].Rental_Start_Date__c,   ISBLANK([Opportunity].Prorated_Move_In_Date__c)))

4 answers
  1. Steve Molis (You Owe Me a Beer, Inc.)
    Jun 27, 2022, 1:25 PM

    You're missing 'quotation' marks on the RecordType.Id

     

    AND( 
    [Opportunity].Account.Parent.Name  = 'MAN Group', 
    [Opportunity].RecordTypeId <> '0121Q000000P0L8QAK', 
    TEXT([Opportunity].Lease_Admin_Fee__c) = '150', 
    [Opportunity].Lease_Expiration_Month__c  <=  6, 
    [Opportunity].Holdover_Rent_Percentage_Increase__c = 0.20, 
    [Opportunity].Rent_Percentage_Increase__c =0.04, 
    ISBLANK(TEXT([Opportunity].Approved__c)),  
    OR(   
    [Opportunity].Prorated_Move_In_Date__c
     <  
    [Opportunity].Rental_Start_Date__c,  
    ISBLANK([Opportunity].Prorated_Move_In_Date__c)
    )
    )
Write an answer...
0/9000