Platform-App-Builder Practice Test
289 Questions
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
A. Option A
B. Option B
C. Option C
D. Option D
Explanation:
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.
| Platform-App-Builder Practice-Test - Home | Previous |
| Page 23 out of 289 Pages |