Ask Search:
Brian HershBrian Hersh 
Hello,

I've created a custom Opportunity Products field that has a picklist of percentages.

I need another custom Opportunity Product field to run a formula based on these picklist percentages.

This may be impossible, as picklists seem to be a read only field.

What's the workaround? I looked up some similar posts, but couldn't find my answer.

Thanks in advance!
Brian
Best Answer chosen by Brian Hersh
Steve MolisSteve Molis
Okay, what is the complete list of Picklist Values?  You could do something like this
 
TotalPrice * 
CASE(Percent__c,
"0%", 0.00,
"10%", 0.10,
"25%", 0.25,
"50%", 0.50,
"75%", 0.75,
"100%", 1.00,
NULL)

 
Matt HowardMatt Howard 
Hi All,

In the sandbox version of Sales force, i have requested the 'Readiness' email, and it confirms that it is 'Connected and Evaluating' but I man not recieving the email. I have tried several times but no luck. If anyone knows why this may be the case than could you please inform me of the reason why this may be occuring.

Any help will be much appreciated

Thanks
Best Answer chosen by Matt Howard
Michelle ArndtMichelle Arndt
I would double check to make sure that you allow "All Email" is turned on in the sandbox, sometimes it isn't.
Setup-->Email Administration-->Deliverability-->Access to Send Email (All Email Services) should be set to All email

 
Bennett LatimerBennett Latimer 
Here is a screenshot depicting what I am trying to explain. 
The closed won is not reflected by the total value won, but the closed lost reflects the total value won. User-added image
Best Answer chosen by Bennett Latimer
Aaron DeRanAaron DeRan
There you go. There is your issue. You need to click Edit next to each value and change the Type value to the correct one.
Sulaiman TabrezSulaiman Tabrez 
Hi Guys,

I need help in creating a workflow. 

I have created a field on the opportunity object called ' Date passed to Sales.'

I need this field populated with the date an opportunity owner is changed from the profile Business Development to someone with a Sales profile.

I can't seem to use the ISCHANGED or PRIORVALUE fucntions without getting errors and i dont know what to do.

Thanks,
Best Answer chosen by Sulaiman Tabrez
Steve MolisSteve Molis
Okay, if you read the Error Message it clearly says that there is no "Owner" field on the Opportunity object.  You should always use the Insert Field button to locate the Field and insert the correct API Field Name in your Formula rather than just typing it in manually.  

Try using 
ISCHANGED(OwnerId)  
 
Karan NayeeKaran Nayee 
I'm trying to create a graph that shows the current and previous value of our pipeline. 

I have sum of value on the y axis 

I want date on the x axis. 

Currently I can only use created date or close date. I need just date. 
Joanne LaverickJoanne Laverick 
Not sure of the best way to do this. I load in opportunities using data tools with a stage of "New" for any that have not been moved from this stage I would like to change the stage to the value "Lost - Expired" when it reaches its close date. Would a workflow rule do the job?

Stage New

 
Best Answer chosen by Joanne Laverick
Jeff MayJeff May
No need for apex.  Time-based Workflow Rules or Scheduled Process Builder actions will do it for you. I like time-based Workflow Rules since they are easier to setup and manage.
Assaf Shisha-HalevyAssaf Shisha-Halevy 
Hello all,
An important KPI I wish to monitor is First Contact Resolution, cases that were marked as "complete" after one iteration, any ideas how to generate a report that measures this?
Thanks so much!
Best Answer chosen by Assaf Shisha-Halevy
Jeff MayJeff May
You can use a Workflow Rule "on create and every edit'. If the Status is 'Complete', and the PRIORVALUE() of Status was 'New' (or whatever your starting status is), then you can set a field "Closed at first contact' on the Case.
Shruthi GMShruthi GM 
Can that button be removed from the layout?
If yes.How could that be possible?
Please help.



Thanks inadvance.
Best Answer chosen by Shruthi GM
Naveen DhanarajNaveen Dhanaraj
Its Standard Functionality we cannot remove.If You would  Like to have This Create a Idea View
Tyson JoeTyson Joe 
I'm trying to do something that I believe is pretty simple but I keep catching errors in my formula.

I have a field called To_Do_Date which if the date is less than today, I want to show the red traffic light.

If the date is today, I want to show yellow.

If the date is in the future, I want to show green.

Here's the first part.
 
IF( To_Do_Date_From_Task__c < Today(),
IMAGE("/img/samples/color_red.gif", "red")

 
Best Answer chosen by Tyson Joe
Chris DuncombeChris Duncombe
Try this
 
IF(
     To_Do_Date_From_Task__c < TODAY(),
     IMAGE("/img/samples/color_red.gif","red"),
     IF(
          To_Do_Date_From_Task__c = TODAY(),
          IMAGE("/img/samples/color_yellow.gif","yellow"),
          IMAGE("/img/samples/color_green.gif","green")
     )
)

 
Stephen ParkinsonStephen Parkinson 
Hi - I am trying to use a formula field on the Opportunity Record to display an image (traffic light type thing) - I have a custom Number field on the Opportunity called 'Number_of_Close_Date_Pushes__c.

I have tried to modify one of the existing formulae in the SFDC Knowledge Base as follows

IMAGE(
CASE(Number_of_Close_Date_Pushes__c, 
"10", "/img/samples/light_red.gif",
"9", "/img/samples/light_red.gif",
"8", "/img/samples/light_red.gif",
"7", "/img/samples/light_red.gif",
"6", "/img/samples/light_red.gif",
"5", "/img/samples/light_red.gif",
"4", "/img/samples/light_red.gif",
"3", "/img/samples/light_yellow.gif",
"2", "/img/samples/light_green.gif",
"1", "/img/samples/light_green.gif",
"/s.gif"),
"Number of Close Date Pushes")

However it throws this error message

Error: Incorrect parameter type for function 'CASE()'. Expected Number, received Text

and I just can't see what the issue is - help please :-)
Best Answer chosen by Stephen Parkinson
Chris DuncombeChris Duncombe
Just need to remove the double quots from around your numbers.  Your Number_of_Close_Date_Pushes__c field is a number field and you are passing in text values as parameters to the case function.  Just remove the quotes like this

 
IMAGE(
     CASE(Number_of_Close_Date_Pushes__c, 
     10, "/img/samples/light_red.gif",
     9, "/img/samples/light_red.gif",
     8, "/img/samples/light_red.gif",
     7, "/img/samples/light_red.gif",
     6, "/img/samples/light_red.gif",
     5, "/img/samples/light_red.gif",
     4, "/img/samples/light_red.gif",
     3, "/img/samples/light_yellow.gif",
     2, "/img/samples/light_green.gif",
     1, "/img/samples/light_green.gif",
     "/s.gif"),
     "Number of Close Date Pushes"
)