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 1	OPTION 2	OPTION 3
A	X
B		X
C			X
D
E	X
F

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?

Accepted answers

Akhtar.shahbaz

Hi @CCOLMANT

You can try the below approach:

All comments

Akhtar.shahbaz

Hi @CCOLMANT

You can try the below approach:

rob_marshall

@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

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385