• DRPowerUser
• NEWBIE
• 25 Points
• Member since 2009

• Chatter
Feed
• 1
• 0
• 0
Likes Given
• 8
Questions
• 12
Replies

I am trying to create a VLOOKUP formula using information from a custom object.

I am getting the message:  “Error: Function VLOOKUP may not be used in this type of formula.  Can anyone explain why I’m getting this error message and how to resolve?

Name = Text    (Example: ABCD1)

Subscription_Year = Text (Example: 100)

Combined Pricing Code = Text  (ABCD1)

VLOOKUP (

Pricing_Code_Lookup__r.Name,

Pricing_Code_Lookup__r.Subscription_User__c,

Combined_Pricing_Code__c)

I am needing assistance with calculating a future date based on the current date + __ Months.  For example:

Current Date = 12/15/2009

# Future Months = 6

Future Date =  06/15/2010

In Excel, the formula is = DATE(YEAR(12/15/2009),MONTH(12/15/2009)+6,DAY(12/15/2009)

What would the formula be in Salesforce to calculate the future date (e.g. 06/15/2010)?

I was trying to use the BLANKVALUE formula to populate the Opportunity Name in a custom text field if the field is currently blank.  I don't know if I need to create an IF formula at same time since if field is not blank, then ignore.

Every time I create formula I get syntax error.

Here's how far I got

BLANKVALUE (Custom_Text_Field_c, Name)

I thought I had my formula working, but when I combine 2 "AND" IF statements together it breaks.

 IF( Qualifier__c <> OwnerId , IF( Users__c < 20, 60, IF( Users__c < 50, 100, IF( Users__c < 100, 250, IF( Users__c >=100, 500,NULL)))),0)

This works fine.

 IF (ISPICKVAL(StageName, "Closed Won"), IF( Users__c<20,150, IF( Users__c<50,300, IF( Users__c<100,750, IF( Users__c>=100,1500,0)))),0)

This works fine.

My issue is that I'm trying to combine the IF statements in each of the first 2 sets of formulas.

 IF (AND (ISPICKVAL(StageName, "Closed Won") Qualifier__c<> OwnerId, IF( Users__c<20,150, IF( Users__c<50,300, IF( Users__c<100,750, IF( Users__c>=100,1500,0))))),0) This creates an error.  Any assistance on how to resolve????

I am trying to create a complex nested IF formula, but I keep getting an error 'invalid parameters'.  Can anyone see what is incorrect?

 IF (ISPICKVAL(StageName, "Closed Won"), IF( Qualifier__c <> OwnerId , IF( Users__c<20,150, IF( Users__c<50,300, IF( Users__c<100,750, IF( Users__c>=100,1500,0 ) ) ) ) ), 0 )

I am trying to revise a formula to do the following:  When Opportuntiy = Closed Won, display a \$\$ based on the value in the custom field called 'Users'.

If users <20   use \$150

If users <50   use \$300

If users <100 use \$750

If users >=100 use \$1500

My issue:  I'm getting a formula error that I can't resolve.

Any help would be appreciated.

I'm currently an SFDC Administrator and Power User.  However, I would like to teach myself to become a Force.com developer.  I don't have any programming background and wonder what are the best steps to learning it.

I have a developer account and have read Force.com Fundamentals Guide, but that's it.

I'm currently an SFDC Administrator and Power User.  However, I would like to teach myself to become a Force.com developer.  I don't have any programming background and wonder what are the best steps to learning it.

I have a developer account and have read Force.com Fundamentals Guide, but that's it.

I am trying to create a VLOOKUP formula using information from a custom object.

I am getting the message:  “Error: Function VLOOKUP may not be used in this type of formula.  Can anyone explain why I’m getting this error message and how to resolve?

Name = Text    (Example: ABCD1)

Subscription_Year = Text (Example: 100)

Combined Pricing Code = Text  (ABCD1)

VLOOKUP (

Pricing_Code_Lookup__r.Name,

Pricing_Code_Lookup__r.Subscription_User__c,

Combined_Pricing_Code__c)

I am needing assistance with calculating a future date based on the current date + __ Months.  For example:

Current Date = 12/15/2009

# Future Months = 6

Future Date =  06/15/2010

In Excel, the formula is = DATE(YEAR(12/15/2009),MONTH(12/15/2009)+6,DAY(12/15/2009)

What would the formula be in Salesforce to calculate the future date (e.g. 06/15/2010)?

I was trying to use the BLANKVALUE formula to populate the Opportunity Name in a custom text field if the field is currently blank.  I don't know if I need to create an IF formula at same time since if field is not blank, then ignore.

Every time I create formula I get syntax error.

Here's how far I got

BLANKVALUE (Custom_Text_Field_c, Name)

I thought I had my formula working, but when I combine 2 "AND" IF statements together it breaks.

 IF( Qualifier__c <> OwnerId , IF( Users__c < 20, 60, IF( Users__c < 50, 100, IF( Users__c < 100, 250, IF( Users__c >=100, 500,NULL)))),0)

This works fine.

 IF (ISPICKVAL(StageName, "Closed Won"), IF( Users__c<20,150, IF( Users__c<50,300, IF( Users__c<100,750, IF( Users__c>=100,1500,0)))),0)

This works fine.

My issue is that I'm trying to combine the IF statements in each of the first 2 sets of formulas.

 IF (AND (ISPICKVAL(StageName, "Closed Won") Qualifier__c<> OwnerId, IF( Users__c<20,150, IF( Users__c<50,300, IF( Users__c<100,750, IF( Users__c>=100,1500,0))))),0) This creates an error.  Any assistance on how to resolve????

I am trying to create a complex nested IF formula, but I keep getting an error 'invalid parameters'.  Can anyone see what is incorrect?

 IF (ISPICKVAL(StageName, "Closed Won"), IF( Qualifier__c <> OwnerId , IF( Users__c<20,150, IF( Users__c<50,300, IF( Users__c<100,750, IF( Users__c>=100,1500,0 ) ) ) ) ), 0 )

I am trying to revise a formula to do the following:  When Opportuntiy = Closed Won, display a \$\$ based on the value in the custom field called 'Users'.

If users <20   use \$150

If users <50   use \$300

If users <100 use \$750

If users >=100 use \$1500

My issue:  I'm getting a formula error that I can't resolve.

Any help would be appreciated.