Skip to main content
Salesforce

Return to Answer

Formatted the answer
Source Link
edit approved May 2, 2017 at 14:06
Samir
edit approved May 2, 2017 at 14:06
Samir
  • 2.7k
  • 1
  • 26
  • 48

Validation rule for your conditions:

  1. RecordTypeRecordType = "Clinical Studies"
  2. Status__cStatus__c = "Draft"
  3. Start_Date__cStart_Date__c && End_Date__cEnd_Date__c are changed.
  4. Date_Change_Reason__cDate_Change_Reason__c should not be null.
AND( 
  $RecordType.Name = "Clinical Studies",
  ISPICKVAL(Status__c,"Draft"),
  ISCHANGED(Start_Date__c),
  ISCHANGED(End_Date__c),
  NOT(
    ISBLANK(Date_Change_Reason__c)
  )
)

Validation rule for your conditions:

  1. RecordType = "Clinical Studies"
  2. Status__c = "Draft"
  3. Start_Date__c && End_Date__c are changed.
  4. Date_Change_Reason__c should not be null.
AND( 
  $RecordType.Name = "Clinical Studies",
  ISPICKVAL(Status__c,"Draft"),
  ISCHANGED(Start_Date__c),
  ISCHANGED(End_Date__c),
  NOT(
    ISBLANK(Date_Change_Reason__c)
  )
)

Validation rule for your conditions:

  1. RecordType = "Clinical Studies"
  2. Status__c = "Draft"
  3. Start_Date__c && End_Date__c are changed.
  4. Date_Change_Reason__c should not be null.
AND( 
  $RecordType.Name = "Clinical Studies",
  ISPICKVAL(Status__c,"Draft"),
  ISCHANGED(Start_Date__c),
  ISCHANGED(End_Date__c),
  NOT(
    ISBLANK(Date_Change_Reason__c)
  )
)
Played around with the formatting a bit so the validation rule could be a code block instead of inline, added indentation to code for readability
Source Link
Derek F
Derek F
  • 64.1k
  • 15
  • 55
  • 104

Validation rule for your conditions:

  1. RecordType = "Clinical Studies"

    RecordType = "Clinical Studies"

  2. Status__c = "Draft"

    Status__c = "Draft"

  3. Start_Date__c && End_Date__c are changed.

    Start_Date__c && End_Date__c are changed.

  4. Date_Change_Reason__c should not be null.

    AND( $RecordType.Name = "Clinical Studies", ISPICKVAL(Status__c,"Draft"), ISCHANGED(Start_Date__c), ISCHANGED(End_Date__c), NOT( ISBLANK(Date_Change_Reason__c)))

    Date_Change_Reason__c should not be null.
AND( 
  $RecordType.Name = "Clinical Studies",
  ISPICKVAL(Status__c,"Draft"),
  ISCHANGED(Start_Date__c),
  ISCHANGED(End_Date__c),
  NOT(
    ISBLANK(Date_Change_Reason__c)
  )
)

Validation rule for your conditions:

  1. RecordType = "Clinical Studies"

  2. Status__c = "Draft"

  3. Start_Date__c && End_Date__c are changed.

  4. Date_Change_Reason__c should not be null.

    AND( $RecordType.Name = "Clinical Studies", ISPICKVAL(Status__c,"Draft"), ISCHANGED(Start_Date__c), ISCHANGED(End_Date__c), NOT( ISBLANK(Date_Change_Reason__c)))

Validation rule for your conditions:

  1. RecordType = "Clinical Studies"
  2. Status__c = "Draft"
  3. Start_Date__c && End_Date__c are changed.
  4. Date_Change_Reason__c should not be null.
AND( 
  $RecordType.Name = "Clinical Studies",
  ISPICKVAL(Status__c,"Draft"),
  ISCHANGED(Start_Date__c),
  ISCHANGED(End_Date__c),
  NOT(
    ISBLANK(Date_Change_Reason__c)
  )
)
deleted 16 characters in body
Source Link
Rohit Mourya
Rohit Mourya
  • 3.9k
  • 2
  • 16
  • 23

Validation rule for your conditions:

Conditions:

  1. RecordType = "Clinical Studies"

  2. Status__c = "Draft"

  3. Start_Date__c && End_Date__c are changed.

  4. Date_Change_Reason__c should not be null.

    AND( $RecordType.Name = "Clinical Studies", ISPICKVAL(Status__c,"Draft"), ISCHANGED(Start_Date__c), ISCHANGED(End_Date__c), NOT( ISBLANK(Date_Change_Reason__c)))

Validation rule for your conditions:

Conditions:

  1. RecordType = "Clinical Studies"

  2. Status__c = "Draft"

  3. Start_Date__c && End_Date__c are changed.

  4. Date_Change_Reason__c should not be null.

    AND( $RecordType.Name = "Clinical Studies", ISPICKVAL(Status__c,"Draft"), ISCHANGED(Start_Date__c), ISCHANGED(End_Date__c), NOT( ISBLANK(Date_Change_Reason__c)))

Validation rule for your conditions:

  1. RecordType = "Clinical Studies"

  2. Status__c = "Draft"

  3. Start_Date__c && End_Date__c are changed.

  4. Date_Change_Reason__c should not be null.

    AND( $RecordType.Name = "Clinical Studies", ISPICKVAL(Status__c,"Draft"), ISCHANGED(Start_Date__c), ISCHANGED(End_Date__c), NOT( ISBLANK(Date_Change_Reason__c)))

Source Link
Rohit Mourya
Rohit Mourya
  • 3.9k
  • 2
  • 16
  • 23