Ask Search:
Steve MolisSteve Molis 
Best practice tip:
Whenever you’re creating a Formula Field, Workflow Rule, Process Builder (or posting a Question about your Formula in the Answers Community), create a List View that includes all of the Fields that your Formula is evaluating side-by-side along with your Formula Field result (if it’s a Cross-Object Formula create a Report).  

Just because you clicked that Check Syntax button and you got that little green message saying “Congratulations!!!  No syntax errors in merge fields or functions. (Compiled size: 4998 characters)” doesn’t mean you’re home free. It just means you have the right combination of AND’s, OR’s, &&’s, ||’s, etc. you could still have a flaw or loophole in your Formula Logic.  

If you think getting a Syntax Error sucks, just wait’ll you have to explain to your boss why their Pipeline and Forecast Reports and Dashboards are wrong because you didn’t check the results of that shiny new Formula Field you built.
[Insert Winston Wolfe’s parable about premature self-congratulation]

Formula with QC List View
User-added image
User-added image

Cross-Object Formula with QC Report
User-added image
User-added image

Best Answer chosen by Steve Molis
Adam MarksAdam Marks
Steve, please make sure to mark a best answer! #keepourcommunityclean!

(that felt so ditry to type)
Chris DuncombeChris Duncombe 
Was informed today that I have been named a Salesforce MVP.  I just wanted to thank everyone as I know the nomination came from within the community.  I am honored and just wanted to say thank you  :)
Best Answer chosen by Chris Duncombe
Jackie DoanJackie Doan
Chris, let's mark a best answer to keep our community clean! 

Haha - had to bust your chops. :)
Alice LeAlice Le 
Hi guys,

Quick clarification question. I keep thinking I can/should use Permission Sets to open up access to a specific group of people - eg, allow my Contracting team read/write permission on Opportunities so they can update some document status fields. However, this doesn't work - I need to open up permission to edit opps via Sharing Rules.

So... when would I use a permission set if it doesn't actually enable access to a field or object? 
Best Answer chosen by Alice Le
Chris EdwardsChris Edwards
Permission sets add the same kind of permissions as profiles give - access to apps, objects, fields, system functions etc - but the only settings that control access to other people's records are OWDs, roles and sharing rules. 

Am I right in thinking the Contracting team do not own the opportunities? If so, this will be why permission sets aren't working for you and why sharing rules are.
Andrey GrinbergAndrey Grinberg 

I am trying to create a roll-up summary field on the campaigns object that uses field data from related opportunity records. However, I am not seeing the option to select Opportunities when I try to create a roll-up summary field.

According to the SalesForce documentation, "roll-up summary fields calculate values from a set of related records, such as those in a related list."

The campaigns object does contain a related list of opportunities. Here is a screenshot of the list as it appears on the campaign page layout:

opportunities related list on the campaign page layout

The campaigns object also has some built-in standard fields which appear to be roll-up summary fields, such as "Total Value Opportunities" which is the sum of the "Amount" field in every related opportunity record. Here is a screenshot of this standard field as it appears on the campaign page layout:

a standard roll-up summary field using opportunities field data on the campaign page layout

However, when I try to create a custom roll-up summary field, I do not seem to have the option to create one that uses opportunities. The only option I have is "campaign members":

no ability to create a custom roll-up summary using opportunities on the campaigns object

Is there a reason why I cannot create a custom roll-up summary field using opportunities despite the fact that the opportunities do look up to the campaigns object, and there are already standard roll-up summary fields that use opportunities on the campaigns object? Is there no way to do this?
Best Answer chosen by Andrey Grinberg
Bill GreenhawBill Greenhaw
Andrey...a few fields out of the box work as rollup type of fields. Those are hardcoded into the product. You cannot change standard fields to master-detail.

If you are a developer or want to try to be a developer you can also look into Apex triggers and these can do the totalling for you since you write all the logic into code. If not then Rollup Helper is the way to go.
Bethann GonzalezBethann Gonzalez 
I need to have a specific lead reocrd type convert to a specific opportunity record type. Is this possible? How would I achieve this?


Best Answer chosen by Bethann Gonzalez
Chris EdwardsChris Edwards
The current solution to this involves creating custom fields and workflow rules. You'd have a field on the lead to hold the name of the record type, then a field on the opportunity to recieve this value from the lead during conversion, and then a workflow rule on the opp that updates the opp record type based on the value in that mapped field. 

This is workable if you a) have workflow available in your edition and b) don't have loads of record types. 

But you should check out the latest product manager comment on - it appears that this is gaining traction and that being able to select an opp record type on conversion could be on its way (at some point - #SafeHarbor). 

Hope that helps. 
Tina PeckTina Peck 
On the Forecasting tab we have access to view an individual user but not a group.
Is there a way to view Forecasting for the entire group?
Best Answer chosen by Tina Peck
Jeff MayJeff May
No.  Forecasting is based on Users and the Forecast Hierarchy.  
Best Answer chosen by Hilliary Hughes
This might happen when the Primary Campaign Source field (in Opportunities) is not visible/editable to the user creating the Opportunity.

This field establishes the relationship between a Campaign and an Opportunity, and if it's not visible/editable, the Opportunity will be created but it will not be associated to the Campaign. 

To make this field visible/editable go to:
Click on Primary Campaign Source
Click on Set Field-Level Security
Tick the box for the profiles that this field should be visible/editable to.
Click Save
Tonya LeeTonya Lee 
I need a custom currency field on Cases that autopops from standard currency field at the Opportunity level. I thought a formula field would work, but I get this error, "Error: Field Opportunity does not exist. Check spelling" with this formula "TEXT(Opportunity.Amount)" 
Best Answer chosen by Tonya Lee
Mayank SrivastavaMayank Srivastava
Tonya, do you have a relationship between Case and Opportunity? Can you check the Case object setup to find out if there's a lookup field pointing to an Opportunity?

Please note that without the above you won't be able to create a formula field on Case.
Daniel FullerDaniel Fuller 
Hello everyone,
I have a question in an area where I am stuck after creating a new stand-alone Lightning app. I do not want to run the Lightning app on the Salesforce1 platform but want to run it on a desktop platform from within the Salesforce org. What process does one have to go through to set up a stand alone Lightning App to be launched from within the Salesforce org? Is there a way to link Salesforce tabs to the Lightning App that will launch the app when they are clicked like you can with Visualforce pages or to add the Lightning App in the Apps menu? I am not able to find any documentation or how to use desktop Lightning Apps from within Salesforce or if that is possible at this time.
Best Answer chosen by Daniel Fuller
Daniel FullerDaniel Fuller
Thank you for the comments. I have discovered a few ways to do this that I wanted to share to this post for others.

1.) You can create a Web Tab and add the hard-coded URL for the Lighting App using the syntax cdylancarter mentioned as the URL. This will open the Lightning App inside of your Salesforce environment; therefore, you will still have the sidebar, header, standard stylesheets, etc.

2.) The more preferable way I have found is to create a Connected App in the Salesforce environment and specify the Lightning App URL as the "Start URL". You can then add the App to the App Launcher and it will appear in your normal app dropdown menu so that you can launch the app directly from there.
Dency JohnDency John 
Some of the converted leads activities fields like task/event record type,assigned to,comments etc are missing while pulling from a custom report type name Lead with or without Activities.
Please help how to populate the values in report.
Best Answer chosen by Dency John
Chris DuncombeChris Duncombe
Correct.  The activities are still there, they are just no longer related to the leads, they are related to the Account, contact or opp they were converted to.