Lesson: 27 | Prevent Open Cases from Being Reset to New

Validation Rule
Page Layout View

Validation Rule

Field	Value
Rule Name	Rulenamehere
Description	If a case is already open, prevents the Status from being changed back to “New.”
Formula:	`AND( ISCHANGED( Status ), NOT(ISPICKVAL(PRIORVALUE( Status ), "New")), ISPICKVAL( Status, "New") )`
Error Message:	Open case Status cannot be reset to New.

You need to login to have access to the quizzes. This lesson has already been completed by you.

Mastered by 48 users.

Exercises

A. Administrator | Exercises (62 lessons)

01 | Brand Theme Settings

02 | Account number must be numeric

03 | Account Number must be 7 digits

04 | Account Site must not be blank

05 | Create Formula_Practice Object for Formula Field Practice

06 | Initials of a Contact

07 | Amount must have a value greater than 0

08 | Calculate the Account Score

09 | Account Number must be numeric and not blank

10 | Verify if a Field's Content Includes a Specified String

11 | Link to LinkedIn

12 | This record is not editable.

13 | Account number is required

14 | Date must be in the current year or in the future

15 | Annual Revenue must be between 0 and 100,000

16 | Billing Street, City and Country are Required

17 | Date must be in current year and month

18 | WebSite must have an extension of com or org

19 | A valid two country code is required

20 | Delivery Date: Max 14 Days After Close

21 | Validate Stage Name of the Opportunity Object

22 | Length of State

23 | A new case with an active account must be prioritized

24 | Phone Number Has International Format

25 | Remaining Days

26 | Close Date Must be Weekday

27 | Prevent Open Cases from Being Reset to New

28 | Amount must have a value greater than 0

29 | The End Date must be after the Start Date

30 | Case Origin cannot be edited

31 | Only admins can change account names

32 | Number must be a positive even number

33 | Invalid Billing State

34 | Invalid Teacher Email Address

35 | Future Birthdate Error

36 | Create Image Based on Rating Value

37 | Creating a Dynamic Validation Rule with Metadata Control

38 | Number must be a positive odd number

39 | Summer Business Hours

40 | Open Opportunities by Stage

41 | Monitor Email Field Changes on Contact Object

42 | Close Date Validation for New Opportunities and Date Changes

43 | Email or Phone Required

44 | Start date must be in the current month

45 | Calculating Sales Tax

46 | Website must end with org

47 | Add Global Login IP Range to System Administrator Profile

48 | Day of the Week

49 | Create Labor Day Holiday

50 | Salary Range Check

51 | Birthday Checker

52 | New Contact Welcome Email Template

53 | Formatted Date

54 | Configure Field Dependency for Industry and Product Interest on Account Object

55 | Length of Account Must be 8 Digits

56 | Calculating Age from Birthdate

57 | Invalid Primary Contact Update for Inactive Account

58 | CloseDate 15 days Ahead

59 | Opportunity Stage Name Order Validation

60 | Track Opportunity Close Date History

61 | Display Status Change Date/Time on Task Object

62 | Restrict Account Lookup to Active Accounts

B. Flow Builder | Exercises (79 lessons)

C. Apex Beginner | Exercises (78 lessons)

D. Apex Intermediate | Exercises (97 lessons)

E. Integration | Exercises (6 lessons)

F. Lightning Web Component (LWC) Exercises (34 lessons)

Lesson: 27 | Prevent Open Cases from Being Reset to New

Validation Rule

Field

Value

Exercises

Login to your account