Ask Search:
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. :)
Kimberly WargoKimberly Wargo 
Hey all,
I have a table chart created in my dashboard. I have a report where I am pulling two summed columns and sorting by office.
"Office" is my grouped field and I have "Inv Total" and "Avg Balance" as my other two columns, average being a formiula in my report.
I am able to sort by office then show both summed total but also want a third colum with record count. Is this possible?
Dasboard Table Chart
Best Answer chosen by Kimberly Wargo
Steve MolisSteve Molis
Then add the "converted" CSF Fields to your Report Chart like this => 
User-added image
Mike ArthurMike Arthur 
I don't recall receiving an email alert for the certification maintenance exams for Winter '16 on either Admin or Dev certs.  Googling for the training resources only revealed that others had noted the same.

To save others the time of hunting for the training material, it's here:
Winter ‘16 Administrator Release Exam (

The modules are listed here:
Winter '16 Release Training for Certified Professionals (

Best Answer chosen by Mike Arthur
Sharif ShaalanSharif Shaalan
Thanks, i was looking for this : )
Patrick QuickPatrick Quick 
Is the Sales Path new feature only for SF1 / Mobile devices, or is it for the std desktop browser as well?

Thanks, Pat
Best Answer chosen by Patrick Quick
Geoffrey FlynnGeoffrey Flynn
Hi Pat,

This is only for Salesforce1 for now
Joseph PhilpottJoseph Philpott 

We want to link up Salesforce with Google Apps but we're having a problem with emails being tracked and added to 'Activity History'. We want to use the feature whereby we press 'Compose Gmail' and a popup comes up. In this email, there is a bbc email address, which is necessary in order to get the email tracked. However, the bcc email address is there but the emails we send aren't being added to the 'Activity History'. 

Can someone help with this please?


Gmail Issue

Best Answer chosen by Joseph Philpott
Joseph PhilpottJoseph Philpott
In the end, the problem was with the 'Advanced Email Security Settings' setting. I unchecked that setting and it fixed the problem.

Thanks Ven and Akhil for your support!
Josh OlsonJosh Olson 
I have a summary report with three columns that I want to display in a tabular dashboard. How can I accomplish this? I can only get one of the numerical columns to display - I want to display the Product, Quantity and Sum of Order Line Total. I'm limiting it to the Top 10 results. Thanks!

User-added image
User-added image
Best Answer chosen by Josh Olson
Steve MolisSteve Molis
Like this =>
1User-added image
2User-added image

2User-added image
3User-added image
Antonio CostaAntonio Costa 

I want a profile to be able to modify fields on the lead even if doesn't own the lead.

could you please let me know how?

User-added image

Thank you
Best Answer chosen by Antonio Costa
Venkata BottaVenkata Botta
You will need "Modify All" permission for the Object in the Profile.

Meghan Campbell (Gaumond)Meghan Campbell (Gaumond) 
I need help with a simple validation rule. When Type equals customer and POS Type equals Unknown OR is Blank. POS Type is a custom lookup field. I’ve tried this:

AND( ISPICKVAL(Type, "Customer"),
POS_Type__c = "Unknown"))

When I test this formula it works when Type is Customer and the POS Type field is Blank; however it does not give an error when Type is Customer and POS Type equals "Unknown". This is my first post to the Community and I'm very excited to have joined. Thanks for any help you can give!
Best Answer chosen by Meghan Campbell (Gaumond)
Mayank SrivastavaMayank Srivastava
Meghan, the issue is that POS Type field is a lookup field in the backend so it is storing an ID. Hence you cannot just say:
POS_Type__c = "Unknown"

What you need to do is go up to the POS Type Name field and then include that in your Validation Rule like this:
  ISPICKVAL(Type, "Customer"),
     POS_Type__r.Name = "Unknown"

I just assumed the Name field so make sure you insert it using the Insert Field button on the formula editor.

POS_Type__r.Name basically means => Traverse to the Name field on related record via POS Type lookup field
Alfredo OrnelasAlfredo Ornelas 
I want to remove "Additional Actions" section from my Lead page layout but I can't find it on my layout...can you help?

User-added image

Below Page layout...

User-added image
Best Answer chosen by Alfredo Ornelas
Deepak AnandDeepak Anand
Looks like your "New" action has been overrided with a Visualforce Page. Can you check that here: Setup | Customize | Leads | Buttons, Links and Actions and click edit next to the New action and check if it has been overrided with a VF Page.
Abby SiskAbby Sisk 
I have a field called 'Regional Ownership' and it is just passing the Region from the Opportunity Owner User Record.  I need it to function as is except on 3 specific accounts, then I need it to be "East".  

Is there a way to write a formula to pass the Region from the user record except for the 3 accounts (using the Account ID) and if that is true then use "East"?
Best Answer chosen by Abby Sisk
Sunil SarillaSunil Sarilla
sorry had an extra parenthesis at the end
CASE(Account.Name ,
"Account Name1",1,
"Account Name2",1,
"Account Name3",1,
"Your Existing formula here "