Sign Up ›
  • Elton dos Santos 4
  • NEWBIE
  • 10 Points
  • Member since 2018
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
SOLVED
5 replies

Validation Rule with Status Case

Hi everyone, can you help me with a rule?

I have a validation rule with 6 level, and I can't to jump this steps, except to the last step(closed). For exemplo: Step 1 to 2 or step 1 to 6 , but step 1 to 3 or 1 to 4 can not. Look how is my code now.

AND
(
    RecordType.DeveloperName = 'test',
    CASE(Status, 
        "step 1",1,
        "step 2",2,
        "step 3",3,
        "step 4",4,
        "step 5",5,
        "Closed 6",6,
    0) 
    !=  
        (CASE(PRIORVALUE(Status), 
        "step 1",1,
        "step 2",2,
        "step 3",3,
        "step 4",4,          
        "step 5",5,
        "Closed 6",6,
    0) + 1)
)

SOLVED
5 replies

Validation Rule with Status Case

Hi everyone, can you help me with a rule?

I have a validation rule with 6 level, and I can't to jump this steps, except to the last step(closed). For exemplo: Step 1 to 2 or step 1 to 6 , but step 1 to 3 or 1 to 4 can not. Look how is my code now.

AND
(
    RecordType.DeveloperName = 'test',
    CASE(Status, 
        "step 1",1,
        "step 2",2,
        "step 3",3,
        "step 4",4,
        "step 5",5,
        "Closed 6",6,
    0) 
    !=  
        (CASE(PRIORVALUE(Status), 
        "step 1",1,
        "step 2",2,
        "step 3",3,
        "step 4",4,          
        "step 5",5,
        "Closed 6",6,
    0) + 1)
)