Hi everyone.I am a beginner in salesforce learining admin part.Can anyone please provide formula for the below que?

Question

Provide the following color coding n the formula field via text depending upon the status of the Employee Green – Employee is active Yellow – Employee is active but on Notice Period Red – Employee is inactive (Hint: Use “/img/samles/color_red.gif” and IMAGE function)

Amnon Kruvi · Accepted Answer

Hi Sagar,

This sounds like it might be an interview question, so I'd much rather help you find the solution than outright give it to you. The following article has public samples of image formulas: (https://help.salesforce.com/articleView?id=useful_advanced_formulas_image_links.htm&type=5)

Let's look at this one:

IF( Case_Age__c > 20, 
IMAGE("/img/samples/color_red.gif", "red", 30, 30),
IF( Case_Age__c > 10,
IMAGE("/img/samples/color_yellow.gif", "yellow", 30, 30),
IMAGE("/img/samples/color_green.gif", "green", 30, 30)
))

This formula applies a color according to a Case Age custom field using an IF.

Do you think you could change the conditions in the IF to meet the conditions for your question? You will need to show red if the employee status is inactive, yellow if he's active but on notice period, and green if he's active.

Aashita Noah · Answer

Hi Sagar,    To solve this question, I'm assuming we have 2 existing fields  1. Is_Active__c  2. Is_on_Notice_Period__c    Therefore, I formulated the following conditions:  1. If the Employee is active and not on notice period, the status should be green.  2. If the Employee is active and on notice period, the status should be yellow.  3. If the Employee is not active and not on notice period, the status should be red.   Converting the algo into code, there you go:   IF( (Is_Active__c == TRUE && Is_on_Notice_Period__c == TRUE), IMAGE("/img/samples/color_yellow.gif", "On Notice Period", 10, 50), IF( (Is_Active__c == TRUE && Is_on_Notice_Period__c == FALSE), IMAGE("/img/samples/color_green.gif", "Active", 10, 50), IF( (Is_Active__c == FALSE && Is_on_Notice_Period__c == FALSE ), IMAGE("/img/samples/color_red.gif", "Inactive", 10 , 50),

Hi everyone.I am a beginner in salesforce learining admin part.Can anyone please provide formula for the below que?

Trailhead Challenges

Formation associée

Aide supplémentaire