Show

sorted by

Over time, I've ended up with a few Success Community Profiles (my usernames from a couple of companies I worked for, and then my "standalone" developer profile). Is there any way to merge the questions/votes/comments, etc of those profiles into 1? I'd like to have a unified presence in the community, if that's possible.

Over time, I could see this becoming a growing issue as multiple people move from company to company that all use Salesforce?

When either or both of these values are selected in the mulit-picklist field: 6TO-FY14-LTD, 8TO-FY14-LTD. The following picklist value: "Marketing Promo" is required to be entered in the "Channel Request Type" field.

I am not sure how to write this validation rule because I keep recieving syntax error: Multi-select picklist fields are only supported in certain functions.

So what I usually do, is I export all the records that need to be updated, making sure to include the ID column, to a CSV file.

Then I export all the users to a CSV file, and move the user ID column to the last column, instead of the first (for the next step)

Then I use a VLOOKUP to pull in the correct User ID to the first CSV file, using whatever criteria needed. (match on email address, for example). Overwrite the existing values in the OwnerID column, or add one with that name if you didn't export it.

Then you just pass the CSV file to the data loader, and choose which fields to map (in this case, you just need ID and OwnerID)

Whenever I open the Lightning for Outlook add-in on an existing email, anyone who is new to my SFDC org shows as a light blue circle and I don't have the option to add them as a new Contact. This just recently happened, and I could have swore that before when anyone new showed up, they had a dark blue + sign and a link to 'Create New' or something like that.

Any ideas on why I wouldn't be able to create a new contact using the add-in?

I would like to capture Act-on Activity history from custom feilds of this third party marketing tool. Salesforce only allows to me to run reports on Activity History for Accounts,LEads, or Contacts not from the actually Third Party history Fields. Please Help!!!

I'm trying to make a formula that tells me the Reporting Week by a date field (in this case, it's a field called Requested Date - which is the date an individual requested a service).

I've looked at so many formulas online and some work except for the end of the year the weeks are -1. I can't seem to find the 1 true formula for determining this. Here is the formula I am currently using.

MOD( FLOOR((DATEVALUE(Requested_Date__c) - DATE(1900,01,01))/7),52)-1

I've tried using -1 and +1 at the end of the formula and neither have worked. Any suggestions? This would be a huge help to everyone I think if we figured this out!