• lburns
  • NEWBIE
  • 25 Points
  • Member since 2004

  • Chatter
    Feed
  • 1
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 15
    Questions
  • 21
    Replies

Hello,

 

This is basically what I'm trying to do, but it makes all probabilities demand the Acceptance Date field be populated..I only want it at 40% above.  What is missing?

 

OR
       (Probability > 30,
    ISNULL( Acceptance_Date__c )
)

 

Thanks...

Message Edited by lburns on 03-23-2010 07:02 AM

I have an open Opps report and need to add another column to it...i.e Net/Margin.  This Net/Margin field has data for all opportunity types, however, I need to show that field in the report but only want data pulled for a particular opportunity type (picklist).  I can make another report and filter it, but there needs to be only 1 report.  This 1 report still has to show all opportunities at the same time.  Possible?  Not seeing how.

 

 

Hi...not sure if this can be done, but i've been asked to group certain stages of an opp...i.e. probability 10, 20, 30% with expected revenue, then probability 40, 50, 70 with expected revenue, then probality 80%, not weighted (with total cost), and lastly probability 90% with total cost.  can this be done on same report??

I would like to make the following rule: 

 

If (addendum #) >0 (problem is that this was created as a text field; afraid I'll lose information if I change the data type) than both the following fields need to be required:

 

Date Field

Text Field

 

Thanks...

 

Hi...There's a standard expected revenue field already showing the weighted average based on another standard 'amount' field, but I need that to reflect on another custom field we call, 'total cost'. 

 

I know I can create a new custom exp. revenue field, but what is the formula to do this?

Hi...I'm trying to create a dashboard showing the following:

 

on the Y-axis: This month (closed month), This Quarter (Fiscal Period) and This Year (FY)

on the x-axis:  Closed Won, Closed Lost, Closed Abandoned (Stage = Closed)

 

I have most of the information created, but am missing one metric no matter how I slice and dice it.  I've tried Summary, Table and Matrix formats.  Is this even possible?  Thx.

 Hi...trying to make a picklist field required when the standard 'TYPE' field (also a picklist field) is populated with 'Vendor'.  If 'Vendor' is selected, then I need to have the 'Vendor Group' field required.

 

 

AND(


    ISPICKVAL( Type ,"Vendor"),
    ISPICKVAL( Vendor_Group__c ) (am I missing something here?)

)

 

I tried the ISNULL function, but it keeps giving me an error that it's a picklist.

 

Thanks...

Hi...trying to insert an Opportunity Validation Rule where if:

 

Label Name, 'Reseller Involved' (field name - 'Reseller_Involved') is picked 'yes, then the lable name 'Reseller Name' (field name - Reseller_Name_ is to be populated/mandatory, before saving the opp.  I am using the following formula and I get this error :  Error:Syntax error. Found 'Reseller':

 

 AND  (
     OR  (
              ISPICKVAL(Reseller Involved, "Yes")),
ISNULL(Reseller_Name__c)
)

 

What is wrong with this?  Thanks in advance for your help.

I am trying to write a validation rule that evaluates if a number field is greater than 0 that a date value must be entered in a date field.

 

Not sure what I am doing. Any help would be great. Thanks.

I am trying to create a validation rule that connects two fields.  For example:  When the Start date is filled out, they have to fill out the End date otherwise an error pops up when they go to save.  I have tried so many different types of formulas but am missing something.  Any suggestions on how to accomplish this?

 

Thanks!

 

Regional bank with large base of salesforce.com users has an immediate full-time, salaried position for an experienced Salesforce.com Administrator to join existing administration team.  Position is based in Richmond, VA and candidates must live in the Richmond area. This position is NOT remote. 

 

Please do not respond if you are looking for contract work.  We are looking to hire a permanent employee.