• lottery sambad
  • NEWBIE
  • -1 Points
  • Member since 2019

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 3
    Replies

I'm trying to create a validation rule  that would prevent a user from saving an opportunity record if a picklist is NULL at the StageName QR Request. 

The below VR gets triggered way before the StageName I listed above. 

Can someone let me know what I'm doing wrong or update this code? 

Thanks

 
AND(
  ISPICKVAL( StageName, 'QR Request'),
  NOT(ISPICKVAL( Qualified_Resolution_Type__c,'ISNULL' ))
)

 
  • November 30, 2019
  • Like
  • 0
I would like to create a check box field thiat is automatically checked base upon the values of two other feilds on the same object.  If the 'project type' pick list feild does not equal 'Windows' and a check box field 'Electrican Required' is unchecked I would like a new check box field I named  'Shutter Permit' to be checked.  I tried reading the formula documentation and came up with something like this as a formula, but I have no idea what I am doing... can someone help me?

If (((Contains(Project_Type__c,"Windows") && ISBLANK(xProject_ElectricianApplies__c)), True, null)