You need to sign in to do that
Don't have an account?
Jane Isaac
Compare 2 checkboxes to complete a text field
I need to compare the contents of 2 checkbox fields. If they both are checked, I want the new field to display "Digital and Physical".
If the digital checkbox field is checked, but the physical one is not, then I want to display "Digital Only".
If the physical checkbox field is checked but the digital one is not, then I want to display "Physical Only".
If neither fields are checked, then I want to display "Neither".
Here is what I have now and I am having problems:
IF(AND(Channel_Digital_Distribution__c, Channel_Physical_Fulfillment__c,"Digital and Physical"),
IF(AND(NOT(Channel_Digital_Distribution__c), Channel_Physical_Fulfillment__c,"Physical only"),
IF(AND(NOT(Channel_Physical_Distribution__c), Channel_Digital_Fulfillment__c,"Digital only"),
"Neither")))
The error message says: "Incorrect parameter type for function 'AND()', Expected Boolean, received Text" and highlights the "Digital and Physical". I can't get any further. Can someone see what is wrong here?
Thanks,
Jane
If the digital checkbox field is checked, but the physical one is not, then I want to display "Digital Only".
If the physical checkbox field is checked but the digital one is not, then I want to display "Physical Only".
If neither fields are checked, then I want to display "Neither".
Here is what I have now and I am having problems:
IF(AND(Channel_Digital_Distribution__c, Channel_Physical_Fulfillment__c,"Digital and Physical"),
IF(AND(NOT(Channel_Digital_Distribution__c), Channel_Physical_Fulfillment__c,"Physical only"),
IF(AND(NOT(Channel_Physical_Distribution__c), Channel_Digital_Fulfillment__c,"Digital only"),
"Neither")))
The error message says: "Incorrect parameter type for function 'AND()', Expected Boolean, received Text" and highlights the "Digital and Physical". I can't get any further. Can someone see what is wrong here?
Thanks,
Jane
IF(AND(Channel_Digital_Distribution__c, Channel_Physical_Fulfillment__c),
"Digital and Physical",
IF(AND(NOT(Channel_Digital_Distribution__c), Channel_Physical_Fulfillment__c),
"Physical only",
IF(AND(NOT(Channel_Physical_Distribution__c), Channel_Digital_Fulfillment__c),
"Digital only",
"Neither")))
IF( AND( Channel_Digital_Distribution__c == False, Channel_Physical_Fulfillment__c == False) , "Neither", IF( AND( Channel_Digital_Distribution__c == True , Channel_Physical_Fulfillment__c == True) , "Digital and Physical", IF( Channel_Physical_Fulfillment__c == True , "Physical Only", IF(Channel_Digital_Distribution__c == True , " Digital Only" , "False") ) ) )
Regards,
Chandra Prakash Sharma
Bisp Solution Inc.