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

CCOLMANT
Occasional Contributor

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

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? 

1 ACCEPTED SOLUTION

Accepted Solutions
Akhtar.shahbaz
Community Boss

Hi @CCOLMANT 

 

You can try the below approach:

Screenshot_261.png

View solution in original post

2 REPLIES 2
Akhtar.shahbaz
Community Boss

Hi @CCOLMANT 

 

You can try the below approach:

Screenshot_261.png

rob_marshall
Moderator

@CCOLMANT 

 

Good question, I would not do a giant IF statement, but rather another boolean line item.  So, Options is a list with a top member (All Options), and A through F is a list (Projects).  Line items would be Valid (this is your boolean or what you currently have as an X), set the summary to Any.

 

In your SYS Projects module (the A through F), create a boolean line item named Valid Options? with the formula: Module.Valid where "module" is your matrix above.  This will return any Project where Options are checked.  This will effectively get you out of the nested IF statement.

 

Does that help?

 

Rob