You need to sign in to do that
Don't have an account?

Help with a formula field. I am brand new to Sales Force
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)
If (((Contains(Project_Type__c,"Windows") && ISBLANK(xProject_ElectricianApplies__c)), True, null)
By the way, you do not need to check for null values on a checkbox field. Checkbox fields can never be null; they are either checked or unchecked and can be set to default to one or the other.