QUESTION: 21

At Universal Containers, the VP of Service has requested a visual indicator flag on each case, based on the case priority. High-priority cases should be flagged red, medium-priorityshould be flagged yellow, and low-priority cases should be flagged green. Which formula would accomplish this requirement? Choose 2 answers

CASE( Priority, "Low", "img/samples/flag_green.gif", "Medium", "img/samples/flag_yellow.gif", "High", "img/samples/flag_red.gif", "/s.gif")
IMAGE( IF(ISPICKVAL(Priority, "Low"), "img/samples/flag_green.gif", IF(ISPICKVAL(Priority, "Medium"), "img/samples/flag_yellow.gif", IF(ISPICKVAL(Priority, "High"), "img/samples/flag_red.gif"))), "Priority Flag")
IF(ISPICKVAL(Priority, "Low"), "img/samples/flag_green.gif", IF(ISPICKVAL(Priority, "Medium"), "img/samples/flag_yellow.gif", IF(ISPICKVAL(Priority, "High"), "img/samples/flag_red.gif", "/s.gif")))
IMAGE(CASE( Priority, "Low", "img/samples/flag_green.gif", "Medium", "img/samples/flag_yellow.gif", "High", "img/samples/flag_red.gif", "Priority Flag")

Answer(s): B,D

Reveal Solution Next Question

QUESTION: 22

What the true statement is in regards to converting a tabular, summary, or matrix report to a joined report? Choose 3 answers

Joined report blocks are formatted as matrix reports.
Bucket fields are not supported in joined reports.
Cross filters are not supported in joined reports
The rows to display filter is not supported in Joined reports
Report formula fields are nor supported in Joined reports

Answer(s): B,C,D

Reveal Solution Next Question

QUESTION: 23

The director of marketing has asked the app builder to create a formula field that tracks how many days have elapsed since a contact was sent a marketing communication. The director is only interested in whole units. Which function should be used to calculate the difference?