s it possible to create a formula in the criteria using these fields? 
If so, what would that look like? 
 

Opportunity.Status__c = Phase I [picklist] Opportunity.Setting__c = Dropped [picklist] Opportunity.StageName = Closed [picklist] Opportunity.Office__c = Waiting [text] Opportunity.Level__c = Personal [picklist]

Hi All..

Will formula field work for permissions for logged in user for formula field?


Thanks,
Chandu

Hey guys,

I'm a real newbie and just can't seem to work. I am needing help writing this validation formula.

Basically, I want a checkbox to only be pressed TRUE if field A + field B + field C is not blank. The checkbox is not always used, so I want this validation to only work when I try to save the record with the checkbox as TRUE.

I tried:

OR(
ISBLANK(fieldA),
ISBLANK(fieldB),
ISBLANK(fieldC))

And this worked, except I can't save the records at all even if the checkbox is NOT ticked...



So I then tried 3 different validation rules separately:

1. 
AND(
     checkbox = TRUE,
     ISBLANK(fieldA)

2. 
AND(
     checkbox = TRUE,
     ISBLANK(fieldB)

3.
AND(
     checkbox = TRUE,
     ISBLANK(fieldC)

This one worked, but it doesn't work together, when I enter value for fieldA and click checkbox, it works and doens't validate the other rules!!



I am thinking it's something like this in a SINGLE formula, but I can't seem to get the validation working...

OR(
    AND(
     checkbox = TRUE,
     ISBLANK(fieldA)),
    AND(
     checkbox = TRUE,
     ISBLANK(fieldB)),
    AND(
     checkbox = TRUE,
     ISBLANK(fieldC))))

But validation doesn't work.... Can anyone help...?