• Terry_0101
  • NEWBIE
  • 155 Points
  • Member since 2014

  • Chatter
    Feed
  • 1
    Best Answers
  • 2
    Likes Received
  • 0
    Likes Given
  • 46
    Questions
  • 28
    Replies
if a user enters a date value into a date field, can a validation field require a specific picklist value?

AND( 
ISBLANK(Ending_Date__c), 
OR( 
ISPICKVAL( Status__c, 'Pink'), 
ISPICKVAL( Status__c, 'Red')))
Hi - how to fix this formula?   If record type is Cake, then make it 0.  Then proceed to add up the Amounts 1-3.

IF( 
RecordType.Name = "Cake",0,
(Amount_1__c + 
Amount_2__c +
Amount_3__c)
This validation rule syntax is fine and saves.  But the opportunity record does not error when the Texture__c field is blank.

AND( 
$RecordType.Name = "REDSHOES", 
Probability > 30, 
OR( 
ISBLANK(TEXT( Texture__c )), 
ISBLANK(TEXT( Category__c )), 
ISBLANK( Amount ) 
))
How to fix this?

When lead owner is changed to this certain person, then do not fire the workflow.

AND( 
LEFT(PRIORVALUE(OwnerId), 3) = '00G', 
LEFT(OwnerId, 3) = '005',
NOT(
$User.Id = "00560000004Yjj5"
))
Hi Gentlemen,

I want to only INCLUDE this Record Type in a formula:   RecordType.Name = "Brazil Deals”


Here is my formula:

January_Revenue__c + February_Revenue__c + March_Revenue__c
Roll ups are disabled in our org due to advanced currency.

Can a trigger be used to count opportunities associated to each contact?
Hi Hi,

If I use CONTAINS, then the letters kent are mixed up with the United Kingdom's Kent state/province.

How to use equals Kentucky instead of contains?

IF(CONTAINS("Kentucky", State )
How to make these profiles exempt from this Validation Ruel?

AND( 
Amount__c > 1, 
ISBLANK(TEXT( type__c )), 
NOT(ISNEW()), 
NOT(OR( 
$Profile.Id<>"00e40000000oRAA", 
$Profile.Id<>"00e4000000132AW", 
)) 
Requirement is:
If a "Payment Made" field has a number in it, then do not allow the "Project Date" to be blank.  Here is what I have but not working.

AND( 
TEXT(Payment_Made__c) = "", 
ISBLANK(Project_Date__c))
How to prevent a record save if two fields on an object have same values?
Need a formula that separates the picklist values of the Opp Type field.  Then show the average age of that opp (created date - closed won).

Need a separate formula rather than use the report's summary formula.
I have a custom object with a lookup relationship to accounts.

I need a trigger that updates an account field when a field from the custom object is populated with a value.
How to make this validation rule work?

ISPICKVAL ( Products__c, "ABC"),
OR
ISPICKVAL ( Products__c, "DEF"), 
AND
ISPICKVAL (  StageName , "Evaluation")
OR
ISPICKVAL (  StageName , "Negotiation")
OR 
ISPICKVAL (  StageName , "Sale Pending"),
ISBLANK(TEXT( Cash_Flow_Forecast_report__c )) 
))))
I have this formula where all 3 fields must be true.  However, the last one Source__c should be OR, not AND.  How to change this?

AND (ISPICKVAL ( Type, "Customer" ), ISPICKVAL ( Status__c , "New" ),
ISPICKVAL ( Source__c , "Webinar" ))
Hi all,

field:  Status
picklist values:  new, open, closed

If status equals either new or open, then add a checkmark to another field

I have so far:
IF(ISPICKVAL(case_status__c, "new" ),"Yes","No")