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 builder ensure this field is properly filled out before setting the opportunity to closed won?
To ensure the 'Scheduled Ship Date' field is properly filled out before setting the opportunity to 'Closed Won', the solution must check two conditions: that the 'Scheduled Ship Date' is not blank and the date difference between 'Scheduled Ship Date' and 'Close Date' does not exceed 14 days. The correct formula for this is ISPICKVAL( StageName ,'Closed Won') && (Scheduled_Ship_Date__c - CloseDate) > 14, ISBLANK(Scheduled_Ship_Date__c)). This effectively ensures the field is always filled before closing the opportunity.
I think option B is the correct answer. Isn't ISPICKVAL(picklist_field, text_literal) the correct way to write it?
Probably B. For A, the shipping date might be left empty for years and the rules won't be triggered. In case, B however you are forced to fill in the shipping date immediately once the opportunity is created. C and D, the is the format for ispickval is incorrect...
Tested this, A is the answer
I think answer B is wrong because it will not be possible to save records that have not been closed and the estimated shipping date has not been decided.
Ans is B OR(ISPICKVAL( StageName ,'Closed Won") && ( Scheduled_Ship_Date__c - CloseDate ) >14,ISBLANK(Scheduled_Ship_Date__c))
B, OR(ISPICKVAL(StageName,Close Won)&& ( Scheduled_Ship_Date__c - CloseDate) > 14, ISBLANK(Scheduled_Ship_Date__c))
B, because the filed need to be filled.
A is correct. in B option ISBLANK is checked without stage name.
ISPICKVAL(picklist_field, text_literal) is the correct one
Blank check with OR condition doe snot make sense as it will fire even if stage != closed won. Out of remaining A and D, syntactically A is correct.
Option A is wrong because Scheduled_Ship_Date__c is Blank then validation will not trigger. Option B is the correct.
It is not B for the reasons I said below my incorrect comment.
A and D don't include if the field is blank. B and C are almost the same except C has incorrect syntax, it should be a "," not an "=" sign after StageName. This code will make it so that the user will get an error message when they try to set the StageName to closed won if either the Scheduled Ship date for shoes is greater than 14 days OR is blank.
Never mind its A, the OR is position so that its (closed won AND >14 days) OR (blank). As someone else pointed out this validation rule will fire all the time until a date is set which would be a problem. Its better for the field to remain blank and the opportunity not closed than it is to have to write a false shipping date just to save the record.
The correct answer is option C: "OR(ISPICKVAL( StageName ='Closed Won') && ( Scheduled_Ship_Date__c- CloseDate ) > 14,ISBLANK(Scheduled_Ship_Date__c))". This formula evaluates two conditions: If the Opportunity stage is set to "Closed Won" and the difference between the Scheduled Ship Date and Close Date is greater than 14 days, then this condition returns false. If the Scheduled Ship Date field is blank, then this condition returns false. The formula uses the OR function to combine these two conditions, so that if either condition is true, then the formula returns true. This ensures that the field Scheduled Ship Date is filled out before setting the opportunity to Closed Won, otherwise, the opportunity record won't be saved.
My bad. The correct answer is option B. The correct syntax would be: ISPICKVAL(StageName, "Closed Won") This formula will return TRUE if the StageName is "Closed Won" and FALSE if it is not.