• SRV-Stephanie
  • NEWBIE
  • 0 Points
  • Member since 2012

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 2
    Replies

I am working on a validation rule that says if the agreement record type is locked and if the user profile is not system admin or contract department then product error. Below is what I have tried, any help would be appreciated.

 

Thanks!

 

AND(
OR(
( AgreementId__r.RecordTypeId, "01I40000000EnhV"),
NOT( $Profile.Id,  "00e40000000jjdK")),
($Profile.Id,"00e40000000jjUh"))

I am  trying to create a new formula field and what I need the formula to do is

 

if checkbox field Bata Agreement is check and if CQI Exisits Rollup is greater than or equal to 1 read true if not read false, below is the formula that I am trying to use. I keep getting an syntax error that i am missing a ')'. I can't figure out what I am doing wrong.

 

IF(

AND(

(Beta_Agreement_c, "1"),

(CQI_Exisits_Rollup_c >= 1),

"TRUE", "FALSE"))

I am  trying to create a new formula field and what I need the formula to do is

 

if checkbox field Bata Agreement is check and if CQI Exisits Rollup is greater than or equal to 1 read true if not read false, below is the formula that I am trying to use. I keep getting an syntax error that i am missing a ')'. I can't figure out what I am doing wrong.

 

IF(

AND(

(Beta_Agreement_c, "1"),

(CQI_Exisits_Rollup_c >= 1),

"TRUE", "FALSE"))