How should the app butler ensure this field is properly filed out before setting the opportunity to closed won?

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?
A . OR(ISPICKVAL( StageName ,"Closed Won") && (
Scheduled_Ship_Date_cCloseDate)>14,ISBLANK(Scheduled_Ship_Date_c))

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

Answer: A

Explanation:

The correct validation rule formula to ensure that the Scheduled Ship Date field is properly filled out

before setting the Opportunity to Closed Won is:

OR(ISPICKVAL( StageName ,“Closed Won”) && (

Scheduled_Ship_Date_cCloseDate)>14,ISBLANK(Scheduled_Ship_Date_c))

This formula checks two conditions: if the StageName is Closed Won and the Scheduled Ship Date is more than 14 days after the Close Date, or if the Scheduled Ship Date is blank. If either condition is true, the validation rule will fire and prevent saving the record. The other formulas are incorrect because they either use incorrect syntax (such as “=” instead of “,” or missing parentheses) or incorrect logic (such as checking if the Scheduled Ship Date is less than 14 days after the Close Date)

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments