I'm getting a difference of 2 hours in two fields on my lead:
Created Time13:46  
Created Date.Time09/10/2017 15:46

Created Time is populated by a workflow rule on lead creation: 
Formula Value:
TIMEVALUE( Created_Date_Time__c )

The field Created_Date_Time__c is a formula field Date/Time.
Formula value:
CreatedDate

Any ideas what is going on?

I'm creating a process builder to add a product to an opportunity when it meets certain conditions. The process works fine when the opportunity is set to our default currency (GBP). However, when an opportunity is in USD I receive an error msg that "An unhandled fault has occured". When I add the Sales Price, is automatically also adds the "£" in front. If I try to remove the Sales Price all together, I also receive the same error. 

I'm using RingCentral with Salesforce and I would like to enable a system where the lead is phoned automatically on creation using the Ring Central softphone. RingCentral says that this feature does not exist with their system. Does anyone know if this can be implemented through Salesforce? 

I'm trying to create a validation rule that requires a custom opportunity field to be populated (look up field) before being able to add a specific discount product to the opportunity. Is this possible? 

AND(
  ISBLANK(Ambassador_Referral__c),
  TEXT(Product2.ProductCode, 'REFDISCOUNT')
)

Error: Field Product2 does not exist. Check spelling.

I'm getting a difference of 2 hours in two fields on my lead:
Created Time13:46  
Created Date.Time09/10/2017 15:46

Created Time is populated by a workflow rule on lead creation: 
Formula Value:
TIMEVALUE( Created_Date_Time__c )

The field Created_Date_Time__c is a formula field Date/Time.
Formula value:
CreatedDate

Any ideas what is going on?

I'm trying to create a validation rule that requires a custom opportunity field to be populated (look up field) before being able to add a specific discount product to the opportunity. Is this possible? 

AND(
  ISBLANK(Ambassador_Referral__c),
  TEXT(Product2.ProductCode, 'REFDISCOUNT')
)

Error: Field Product2 does not exist. Check spelling.

In Sweden and some other parts of Europe the week numbering is often using the ISO 8601 standard that says that the first week of the year is the first week with at least 4 days in the new year. Some consequences of this is that the final dates of one year can be week 52, 53 or even week 1( in the following year). The same goes for the first dates of a year.

 

To be able to do weekly comparison report Year-to-Year with this weeknumbering it is necessary to create custom fields for the opportunity that calculates the Year and Week number for a given close date. Here is one solution using three custom formula fields.

 

Field: Global Sales Report Weekday

Description:  Day 1 = Sunday, 2 = Monday....., 7=Saturday

Formula:  MOD( CloseDate  - DATE(1900, 1, 7), 7)+1

 

Field: Global Sales Report Week Year

Formula: YEAR(CloseDate + (MOD(8- Global_Sales_Report_Weekday__c ,7)-3))

 

Field: Global Sales Report Week

Formula:

FLOOR((CloseDate - DATE( Global_Sales_Report_Week_Year__c ,1,1) +
MOD(
(MOD( DATE(Global_Sales_Report_Week_Year__c,1,1) - DATE(1900, 1, 7), 7)+1)
+1,7)-3) / 7 + 1)

 

Hope this can be of use for anyone else

 

Peter Baeza

InfoAction AB, Sweden