Filtering a subset

Sachinsourav02 · 2024-11-05T07:05:44+00:00

There was an error rendering this rich post.

Anaplanners,

Is there a way i can filter a subset ?

So, we have Projects module, where each project can be either active, inactive or done. This is a list formatted line item.

However, the option to select done should be based on another line item in the module, actuals uploaded : Yes/No ? If the boolean is true only the Project can be marked "done". So the dropdown which has the subset should change based on on "Actuals Uploaded" line item

Accepted answers

AjayM

Hi @Sachinsourav02 ,

Depending on your requirement, you can follow either one-to-many picklists or many-to-many picklists, basically using dependent dropdown feature.

If 'DONE' is valid only for TRUE check, and ACTIVE/INACTIVE are valid only for FALSE check, it would be a simpler one-to-many approach.
If ACTIVE/INACTIVE are valid for both TRUE and FALSE checks, then it would become a many-to-many approach.

Cheers!

All comments

AjayM

Hi @Sachinsourav02 ,

Depending on your requirement, you can follow either one-to-many picklists or many-to-many picklists, basically using dependent dropdown feature.

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…