• Denise Wilhite 6
  • NEWBIE
  • 0 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
I need some help please with a formula field.   I am trying to write a formula that references another field on the same object that is a picklist field.    I want to have the value in this new field to be based on the picklist value from the other field.  The formula that I am trying to write consists of:
 
IF(ISPICKVAL(Loan_Documentation__c = "Attorney Prepared", Yes,Bypass CDP,
ISPICKVAL(Loan_Documentation__c = "Internal Loan Agreement and Attorney Closed",Yes, Bypass CDP,
ISPICKVAL(Loan_Documentation__c, = "Internal Loan Agreement and No Attorney Closed", No,
ISPICKVAL(Loan_Documentation__c, = "No Loan Agreement Needed", No
)
)
)
)
)
I get an error message with this that states "Error:  Syntax error.  Found 'Bypass'.    What am I doing wrong?
 
Thank you!