CRT-403 practice question 8 of 35

Cloud Kicks (CK) Is finding sales reps are Inconsistent in data entry when deals are won. CK requires that custom shoes are shipped within two weeks after the close date. A custom field called Scheduled Ship Date on the opportunity records the ship date.How should the app butler ensure this field is properly filed out before setting the opportunity to closed won?

Full set: 291 questions
Answer options
A: OR(ISPICKVAL( StageName ,"Closed Won") && ( Scheduled_Ship_Date_cCloseDate)>14,ISBLANK(Scheduled_Ship_Date_c)) Correct answer
B: OR(ISPICKVAL( StageName ="Closed Won") && ( Scheduled_Ship_Date__c- CloseDate ) > 14,ISBLANK(Scheduled_Ship_Date__c))
C: ISPICKVAL( StageName ,"Closed Won") && ( Scheduled _Ship_Date_c-CloseDate ) > 14
D: ISPICKVAL( StageName= CloseDate ) > 14,losed Won") && ( CloseDateScheduled_Ship_Date_c) >14
Correct Answer:
A. OR(ISPICKVAL( StageName ,"Closed Won") && ( Scheduled_Ship_Date_cCloseDate)>14,ISBLANK(Scheduled_Ship_Date_c))
Explanation

This validation rule formula is intended to ensure data integrity when an opportunity's stage is set to "Closed Won". The formula combines two conditions using the OR logical function. The rule will trigger an error if either:
1. The ScheduledShipDatec field is left blank (ISBLANK(ScheduledShipDatec)).
2. The StageName is "Closed Won" AND the ScheduledShipDatec is more than 14 days after the CloseDate. This structure ensures that both requirements—that the field is populated and that the date is within the allowed timeframe—are checked before the record can be saved as "Closed Won", thus fulfilling the business requirement.

Why Incorrect

B: This option is functionally identical to option A, containing the same logic and structure. It is also considered the correct answer for the same reasons. C: This formula is incomplete. It only validates that the ship date is not more than 14 days after the close date but fails to check if the ScheduledShipDatec field is blank. D: This formula is syntactically invalid and contains multiple errors. It would not be accepted by the Salesforce formula editor and is non-functional.

References

1. Salesforce Help: Validation Rules. This document outlines the purpose of validation rules, which is to "verify that the data a user enters in a record meets the standards you specify before the user can save the record." The scenario described is a primary use case for a validation rule.

Source: Salesforce Official Documentation, "Validation Rules".

2. Salesforce Help: Formula Operators and Functions I–Z. This document provides the syntax and usage for Salesforce formula functions.

ISPICKVAL(picklistfield, textliteral): "Returns true if the value of a picklist field is equal to a text literal you specify." (Section: ISPICKVAL)

ISBLANK(expression): "Returns true if an expression has no value." (Section: ISBLANK)

OR(logical1, logical2, ...): "Returns true if any expression is true." (Section: OR)

3. Salesforce Help: Using Date and Date/Time Values in Formulas. This document confirms that subtracting one Date value from another (e.g., ScheduledShipDatec - CloseDate) results in the number of days between them, which is the correct method for this calculation.

Source: Salesforce Official Documentation, "Date and Date/Time Formulas", Section: "Subtracting Dates".

Scroll to Top