IF user Selects any checkbox within 3 booleans then I want to include that in a scope

Options
CCOLMANT
CCOLMANT Member, ALL USERS Posts: 5 Occasional Contributor

Hello, 

 

I am wondering if I can use the IF formula to say that if a user selects any of the checkboxes within three separate columns (booleans) then I want to consider that within a scope. 

 

 OPTION 1OPTION 2OPTION 3
AX  
B X 
C  X
D   
EX  
   

 

Let's pretend this is the dashboard and that the "x" represent a check in a boolean list 

 

Then I want to say that from those items only A, B, C and E are my scope

 

Do you have any solutions? 

Tagged: