ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 270 - Certified Platform App Builder discussion

Report
Export

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?

A)

B)

C)

A.
Option A
Answers
A.
Option A
B.
Option B
Answers
B.
Option B
C.
Option C
Answers
C.
Option C
D.
Option D
Answers
D.
Option D
Suggested answer: B

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.

Reference for creating formula fields in Salesforce:

Formula Field

Reference: https://help.salesforce.com/articleView?id=sf.customize_functions.htm&type=5

asked 23/09/2024
Russell James
38 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first