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. :)
Megan BlumenthalMegan Blumenthal 
Shameless plug to vote for our idea to add a toggle to the email sender workflow in Pardot for choosing if you want that email synced to Salesforce as an activity or not. Currently everything either syncs or doesn't based on your Connector settings.
Best Answer chosen by Megan Blumenthal
Pritam ShekhawatPritam Shekhawat
Hi Megan,
               You should post your idea in Pardot user group . As here maximum users  don't have pardot account for vote on this idea. Post your idea here 

Pritam Shekhawat
Sean SullivanSean Sullivan 
I would like to create a formula field that will calculate the transaction fee based on the payment method value.
  • If Payment Method Value = "Online Form" then the fee would calculate as Payment Amount field value x 2.2% + $.30
  • If Payment Method Value = "PayPal Here Swipe" then the fee would calculate as Payment Amount field value x 2.7%
  • If Payment Method Value = " PayPal Here Keyed" then the fee would calculate as Payment Amount field value x 3.5% + $.15
Any suggestions would be greatly appreciated!
Best Answer chosen by Sean Sullivan
Steve MolisSteve Molis
Here you go:
(Amount_Field__c * 
"Online Form", 0.022,
"Online Form", 0.027,
" PayPal Here Keyed", 0.035,
0)) +  
"Online Form", 0.30,
"Online Form", 0.00,
" PayPal Here Keyed", 0.15,

Bill DavisBill Davis 
We use campaigns for our annual conference (and other events) and we want to be able to use the Salesforce 1 mobile application to help us check in members that have actually attended the conference.

When using the Salesforce 1 application and open up the specific campaign that represents our annual conference, then navigate to the related list and click on campaign members I was expecting to see a list of all members.  Instead I get a single column that lists each of the members, but is only showing the 'Member Status' for that individual campaign member.

When I select a row, I get into the campaign member, but do not have the ability to update the member status from within the application. 

Two things:
  • Is there a way to configue SF1 to allow me to edit the member status for those that are on a campaign?
  • Is there a way to configure SF1 to allow me to see the member names instead of the member status?
This would solve a HUGE gap we have in how we handle the check in process and would love to know if this is possible or not.
Best Answer chosen by Bill Davis
Ahmad HelalAhmad Helal

As for your other issue, there is this idea you can vote on...

Here is a work around to ADD a member but still not edit, but again odd that it's not standard functionality:
Rebecca RallsRebecca Ralls 
I am having a great deal of trouble trying to sort this out. I have a matrix report that looks like this:

Reservation Matrix report

Where Current season and last season are formula fields and Res Pop % Growth is a Report Formula. per the recommendation of this article:  But I'm not getting the sortting and/ore the formulas right, somehow, and am not getting the results I want.

What I want is for Res pop % growth to calculate a year over year % growth, I need to find a way to get the "Current Season" and the "Last Season" - or maybe even only the "last season"? - formulas to calculate accurately for every year - not just the current year and last year.

And I am suffering a complete lack of inspiration as to how to make it do that.


Best Answer chosen by Rebecca Ralls
Steve MolisSteve Molis
Holy S#*+  

I think I might have it!  #SafeHabah
User-added image 
Karen MansellKaren Mansell 
 I am trying to create a standard report that filters out all Contacts that have text in a particular field, leaving only Contacts where the field is empty. I can't work how to do this as there is no filter called "Where field is Blank", and when I select the Filter "Equals to" and leave the field blank or type BLANK  in the filter criteria box I get no results.
Best Answer chosen by Karen Mansell
Steve MolisSteve Molis
As you can see from my screenshot using 

Filtered By:  
    Mailing Street equals  <blank>  

worked on my Dev SFDC org
Mikey JamJamsMikey JamJams 
I'm setting up Live Agent for the first time and noticed that Supervisors can have additional permissions. However, how do you indicate someone is a Supervisor? I was expecting some sort of Supervisor User permission on the user record or profile, but I haven't seen anything. I did notice a Live Agent Supervisor tab; so, does that mean if someone's profile has access to the Supervisor Tab they are a supervisor?

Best Answer chosen by Mikey JamJams
Tami EslingTami Esling
Hi Mikey,
I think is it mainly through access to the Live Agent Supervisor tab - either you have access to the Tab, or you don't.

You can assign tab visibility through Profiles, or an alternative way is through Permission Sets.

This should lead you in the right direction - 
Kevin KKevin K 
I would like to run a report that shows how long opportunities that were closed won were in certain stages.  Would like it to appear as a matrix report, similar to the below example:

 User-added image

Is this possible?  Essenitally, I would like to be able to report on how long certain opportunities were in certain stages and work with sales reps to help identify if/where there is room for imrpovement.

Ideally, we would also want to be able to use this for open opportunities, as well, so that we can see if anything is stuck and help push it through.
Best Answer chosen by Kevin K
Kevin KKevin K
Thanks, Steve.  Looks good!
Nick VastanoNick Vastano 
I am wanting to create a formula for a custom field that is completely dependent on whether or not certain check boxes have been checked or not. 

I have two columns in my object. there are five checkboxes in the left column that when checked, each one will add a value of .5 to the baseline of 2.5 (i.e. two checkboxes would add 1 point to 2.5 giving me 3.5). The right column contains 5 check boxes that when checked would subtract .5 from the baseline 2.5.

Screenshot example of the two columns is below:

User-added image

The field for Qualitative Measures Score is my custom formula field i am editing.

Basically if all five checkboxes on the right are checked and none on the left, the total Qualitative Measures Score would equal 5.

There can be a mixture of checkboxes from both columns.

Thank you to anyone who can help me create this formula.
Best Answer chosen by Nick Vastano
Deepak AnandDeepak Anand
Sure thing!

Try this - 

        IF(Left_Checkbox_1__c, 1, 0) + 
        IF(Left_Checkbox_2__c, 1, 0) + 
        IF(Left_Checkbox_3__c, 1, 0) + 
        IF(Left_Checkbox_4__c, 1, 0) + 
        IF(Left_Checkbox_5__c, 1, 0)
    ) * 0.5

        IF(Right_Checkbox_1__c, 1, 0) + 
        IF(Right_Checkbox_2__c, 1, 0) + 
        IF(Right_Checkbox_3__c, 1, 0) + 
        IF(Right_Checkbox_4__c, 1, 0) + 
        IF(Right_Checkbox_5__c, 1, 0)
    ) * 0.5