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 (http://certification.force.com/pkb/articles/Public_KB/Winter-16-Administrator-Release-Exam/?q=winter+16&l=en_US&fs=Search&pn=1)

The modules are listed here:
Winter '16 Release Training for Certified Professionals (https://help.salesforce.com/HTTrainingModulesDetail?courseId=a1S300000032xGB)

 
Best Answer chosen by Mike Arthur
Sharif ShaalanSharif Shaalan
Thanks, i was looking for this : )
Bill DavisBill Davis 
I am looking to create a custom formula campaign member field that looks at an identical field that exists at the lead and contact level. 

For example, I have a need to display all campaign members that have are publically listed on an exchange, the field that exsists at both the contact and lead level is called 'Ownership' (picklist) that contains values:
  • Public
  • Private
I wanted to create this custom formula field to show the text value of each contact / lead that has the 'Ownership' field in the a single field.

Is there a way to create a text formula field that looks at both the contact and lead to display a value in this combined campaign member field?

When creating a text field for just contacts, I created the following formula field and it works well - Text (Contact.Account.Type), but now I need to look at two objects to populate this one field.

Any tips or ideas?
Best Answer chosen by Bill Davis
Geoffrey FlynnGeoffrey Flynn
Something like this should work:
IF(
NOT(ISBLANK( ContactId )),
 TEXT(Contact.Ownership__c ),
 TEXT(Lead.Ownership__c)
)

 
Anne LewsonAnne Lewson 
I would like to build a report that shows : Accounts / #of Won opp. / Volume for these Won Opp. across 2 separate time periods Jan 1 2015 to May 23 2015 and Jan 1 2016 to May 23 2016. (current date)
Side by Side.
mockup of report layout
Could you put me in the right direction please? thank you
Best Answer chosen by Miglena (Salesforce.com) 
Steve MolisSteve Molis
I would start by creating a custom Formula(Checkbox) field on the Opportunity to use in your Report Filter 
You Formula would be something like this:
 
AND( 
(CloseDate - DATE(YEAR( CloseDate ), 1, 1) + 1) <= (TODAY() - DATE(YEAR( TODAY() ), 1, 1) + 1))

 
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 
Hi,

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?

Thanks!

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 
Hi,

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.

Best
Ven
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"),
OR( ISBLANK(POS_Type__c),
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:
AND( 
  ISPICKVAL(Type, "Customer"),
  OR(
     ISBLANK(POS_Type__c),
     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