Ask Search:
David DavidDavid David 
I know i'm not crazy.  Been on SF classic for 10 years.  The recent items list in the sidebar now puts tasks and all other junk in there where it was always showing me the ACCOUNTS we were at.  What changed?  It has become useless as it fills up with junk I do not need.  People at SF tell me nothing changed???  IMPOSSIBLE!!  Every worker of mine has complained about it and I have no idea what has happened.  ANYONE having this issue and how do we make it go back to how it was...Thanks
Best Answer chosen by David David
Prashant PandeyPrashant Pandey
Hi David,
Unfortunately, you can not customize the recent item..but there is a workaround.
Step 1 : Create a home page component and use this query within the controller and
FROM RecentlyViewed 
WHERE Type IN ('Account')
ORDER BY LastViewedDate DESC

display the account name in the homepage component. 

Step 2:

Go to homepage layout and remove the standard recent item option. 


Step 3: Select the newly created component 
Step 4:
Specify the custom component location within the homepage.


Ashley SistiAshley Sisti 
Hello all,

I need a formula that will correctly calculate the number of months between two dates, assuming that any days less than 1 month would count as 1. 

For the following date fields, it should return:

Contract Start Date:  6/1/2015
Contract End Date: 5/31/2016
12 months

Contract Start Date: 2/12/2015
Contract End Date: 2/11/2020
60 months

Contract Start Date: 7/1/2015
Contract End Date: 7/15/2015
1 month

I've tried several formulas I've seen posted here in the success community, with varying degrees of success. None give me what I'm looking for for all of the scenarios above - I either get 11 months for the 1 year contract, or 59 months for the 5 year. Please help! Thanks!
Best Answer chosen by Ashley Sisti
Paul B. FischerPaul B. Fischer
Can you try this? 
(testdate2__c - testdate1__c) / 365 * 12 < 1, 1, (testdate2__c - testdate1__c) / 365 * 12

I tested it against your scenarios and it should work.

Best regards,
Katherine RoweKatherine Rowe 

Ok a basic question on assignment rules.

If you use an assignment rule while creating a lead (whether its created manually, through import wizard, or other tool), every subsequent time you edit anything on the lead, it triggers the assignment rule again? Forever? And if you create lead without an assignment rule, it will never use an assignment rule on it? Ever?

How does salesforce keep track of the ones created with assignment rules in order to remember to run the assignment rule again for every subsequent update? I don't see a field on the Lead object where that information might be stored?

Best Answer chosen by Katherine Rowe
Derek HughesDerek Hughes
I dont think it works like you described.  

Lead assignment rules run differently based on how the lead is created.  
1. Lead import wizards - you get to chose which assingment rule to use, or NONE
2. Through other tools - it will depend on how they are written, but most in my experience cause lead assignment to apply
3. Manually created through the 'New' button on the user interface - this will depend on the page layout properties.  On the properties you can chose if the Lead Assignmen Checkbox should be disaplayed for users to select whether to apply lead assingment rules and whether it should be checked by default.  So you can make it always apply, never apply or leave it up to the user

When leads are edited it is only governed by the page layout properties, but will behave differently for full edit and in-line edits.
1. Full edit - works like a new lead as the checkbox might be visible and then the user can choose, or its always on or always off.
2. Inline edit - the user will never get the option to chose the behaviour as there is nowhere to see the checkbox.  So it may will be that the lead assingment rules run everytime a lead is edited inline.

Finallyyou can setup the lead assingment rule NOT to change the owner based on criteria - so its possible to have a rule that will not assing existing leads, or leads in a certain status and so on.  So even if you have setup the page properties to always run the assingment rules you can control when they will apply.

Hope that helps...

User-added image

Elaine SawfordElaine Sawford 
I'm trying to create a Lookup Rollup summary to coun the number of Opportunities related to a Contact which are not yet confirmed, created this year, at a specific venue and only for specific events. The formula was calculating correctly until I then needed to only include records where the "SG Event Name" value contains "NYE" or "New Years Eve"

I expressed it as per below but it is not calculating correctly so the error must be in the last section. Can anyone offer any tips?

Also, I next need to create a formula to EXCLUDE records where this is the case, so essentially I need records where the SG Event Name DOES NOT CONTAIN "NYE" or "New Year". How would I express DOES NOT CONTAIN in this instance?

Thank you!

RecordType.Name='Shared Christmas Party' AND StageName!='Confirmed - Closed Won' AND CreatedDate= THIS_YEAR AND Venue__c='Battersea Evolution' AND Other_Event__r.Name LIKE '%New Year%' AND Other_Event__r.Name LIKE '%NYE%'
Best Answer chosen by Elaine Sawford
Amnon KruviAmnon Kruvi
Oh, sorry, let's try a slightly different format then:
RecordType.Name='Shared Christmas Party' AND StageName!='Confirmed - Closed Won' AND CreatedDate= THIS_YEAR AND Venue__c='Battersea Evolution' AND (NOT Other_Event__r.Name LIKE '%New Year%' AND NOT Other_Event__r.Name LIKE '%NYE%')

Joseph MiramonJoseph Miramon 
I am trying to set up new users for testing our new app, but just for the sandbox environment. They do not have any current user licenses in the production environment. So, what I did was I created a new user in sandbox, and the new user got a welcome email, but they did not get a prompt to set a new password (like setting up one in production). Thus, they cannot log in.

Do you guys know of a way to just create pure sandbox users without matching what's in production?
Best Answer chosen by Joseph Miramon
Pritam ShekhawatPritam Shekhawat
Yes you can create a new user without adding them into production. The username should follow the same syntax as your other users, which is username.sandbox name. Goto>User detail page and check the checkbox Generate new password and notify user immediately" or you can reset the password for that user.
Laurence BergLaurence Berg 
I am trying to manage the libraries in our Org. I am a System Administrator.
I would like to have the Files functionality in Lightning, but I understand that I have to create/manage the libraries available there from the Classic UI.
I found the Salesforce Files Settings and enabled Libraries in Salesforce Files under General Settings.
Under Salesforce CRM Content, I clicked "Enable Salesforce CRM Content".

I have NOT found "Content Permissions" described in the SFDC Documentation or the "Manage Salesforce CRM Content" and the "Add LIbrary Permissions" described there. Guessing that it's outdated, but no updated documentation seems to exist.

So, I would like help to set up libraries to work in the Lightning Files tab. Right now, I've got "Assets" by default, which I'd like to remove or rename.

Best Answer chosen by Laurence Berg
Greg OwenGreg Owen
On the user record is "Salesforce CRM Content User" checked ?
Paul BlomerthPaul Blomerth 


We have 3 fields on the account level that, based on what is or isn't in those fields, we'd like to return the value of "Paying" or "Canceled". Could someone please help me with the formula to get it to work as follows:

If the Churn date field is not blank and the Status ID field is not blank, return the value of 'paying.' OR, if the parent ID field is not blank (and regardless of what is in the churn or Status ID fields), return the value of paying. For everything else, label it as "Cancelled" 

I currently have this formula which works for the first scenario, but I can't figure out how to insert the piece regarding the parent ID not being blank to return the value of 'paying.'

IF( ISNULL(Churn_Date__c) && NOT(ISBLANK(Status_ID__c)),"Paying","Canceled")



Best Answer chosen by Paul Blomerth
Narender SinghNarender Singh
Like this:
    IF( AND(NOT(ISBLANK(Churn_Date__c)),

NOTE: Use the correct API Names of the fields. Use 'Insert Field' button.
Dan LutonDan Luton 
I assume this has been asked many times before but all the answers I have found relate to field level security which is not an issue.

I am logged on as an administrator and am trying to run a custom report on Contacts related to a Custom Object. There are multiple number fields in the object which I was able to report on yesterday, but all of the fields I have created today do not appear in the Available Fields in the custom report now. They are configured in exactly the same way as previous number fields, I have access to them in the Field Level settings and there are no Sharing restrictions in place in this App. I also have access to the Record types through my profile.

I can even see and edit the fields in the custom object but am then not able to report on those edits.

Any ideas?
Best Answer chosen by Moderator ( 
Elizabeth DavidsonElizabeth Davidson
Actually this is  an easy one but hard before you've come across it!

What you need to do is go back into the custom report type, you'll need to add the fields you created since creating the custom report type to be available in the report type.

WHY on earth this is not something to choose during field creation I have no idea, but that's what is happening.  

here's a link to more details- it's talking more in terms of the old report builder but you'll get the idea of what to do:

Good luck! And don't feel bad, I was ready to scream until I figured this out!
Matthew PiazzaMatthew Piazza 
Hi All- I wrote this formula to return a "week of the year" if one certain value is selected from a picklist.

However the way I wrote it, it is returning a zero if another picklist value is selected, and I'd like it to return nothing/remain blank.
CASE(TEXT(Feedback_Type__c), "Weekly Summary",
IF(CEILING((Feedback_Effective_Date__c - DATE(YEAR(Feedback_Effective_Date__c), 1, 1) + 1) / 7) > 52,
CEILING((Feedback_Effective_Date__c - DATE(YEAR(Feedback_Effective_Date__c), 1, 1) + 1) / 7)
If I replace the <, 0> above with <, " ">, I get a syntax error, which makes sense (I think?):
Error: Incorrect parameter type for function 'CASE()'. Expected Number, received Text

Thank you in advance for any assistance!
Best Answer chosen by Matthew Piazza
Jeff MayJeff May
instead of the 0, put null
Christina IanssenChristina Ianssen 
We are a battery manufacturer that supplies to technology firms in the marine industry. Often there will be different technology firms bidding on one project, and they will all request a system solution from us as part of their bid. This creates a problem as sometimes we end up thinking there are more opportunities than there actually are. That's why we want to be able to have one opportunity which is the project, and then link the different accounts (technology firms) to this opportunity. 
Is this possible? 
Best Answer chosen by Christina Ianssen
Head In CloudHead In Cloud


Below are the steps to create master detail lookup:-
  • Click on setup and search objects. Click on the objects link.
  • All of the custom objects will be shown there. You need to click on the custom object which you have created for this requirement. Lets say Opportunity Relation object which i have assumed on my answer.
  • Click on the New button in the Custom Fields & Relationships area.
  • Click on the Master Detail relationship radio box and hit on next button as shown below.User-added image
  • After hitting next button select a value in Related To field. Select Account in the dropdown field and hit next.
  • Provide some name in Field Name text box lets say Account and hit next button.
  • Again hit next in step 4 and step 5.
  • In last step i.e. step-6 hit save.
  • Your master detail field on Account will be created.
  • Do the above steps again and select Opportunity in step-2. Then your master detail field on Opportunity will be created.

Hope this helps. Do let me know if you have any doubt. If you liked my answers please mark it as the best answer. Thanks!!