Universal Containers wants to create a custom checkbox formula field on the Opportunity object. This formula should evaluate to true if the following conditions are met:
* Stage is set to Negotiation/Review
* Close Date is less than 1 week away
Which formula meets these requirements?
Correct Answer: B
For a formula to evaluate to true when the stage is set to "Negotiation/Review" and the close date is less than one week away, the correct formula is:
Option B. This formula uses the ISPICKVAL function to check the text value of a picklist and compares the CloseDate to a week from today:
AND( I AND(
ISPICKVAL(StageName, "Negotiation/Review"),
CloseDate - 7 < TODAY()
)SPICKVAL(StageName, "Negotiation/Review"), CloseDate - 7 < TODAY() )
This formula checks that both conditions are met: it confirms the stage name is "Negotiation/Review" and that the CloseDate is within the next 7 days from the current date.
Option A lacks the ISPICKVAL function necessary for evaluating picklist fields. Option C uses DAY(7) which is not a valid Salesforce formula expression. Option D also uses DAY(7) incorrectly and fails to use the ISPICKVAL function.
Reference for creating formula fields in Salesforce:
Formula Field Reference: https://help.salesforce.com/articleView?id=sf.customize_functions.htm&type=5