SET CHECKBOX value through a given condition

Hi Everyone!

There is a way to set one line item boolean to TRUE to specific condition and make it editable for other condition ?

On the example below, "Main process" is checked i need to check the "Process Comp" on the same line and make the above enabled to edition (check/uncheck), is it possible ?

I'm trying to set using IF condition but doesnt work ...

Thank you!

Accepted answers

All comments

JaredDolich

@jbaudino1

Yep, you can do that by using Dynamic Cell Access. You have three choices based on a Boolean.

Read Only
Edit
Invisible

Here's a great explanation of how to use DCA. That's your best bet!

https://help.anaplan.com/en/d10ce953-9063-405f-b146-e7d5e55383e2-Dynamic-Cell-Access

here's an example for you.

Set up your Line items with DCA using the Main Process Comp as the Boolean. Or if you need to reverse the Boolean, meaning when it's false then create another Boolean line item = NOT Main Process Comp.

When Main is checked then Process Comp opens up and is now editable.

ChrisAHeathcote

@jbaudino1

As I understand you would like to have one condition of the boolean driven by a formula and the other by the user as an editable input.

If this is correct then it is not possible to combine these within the same line item.

You will need to create one line item which is driven by a query, another by the user and a final line item which combines the conditions to be used in downstream processes.

The only time you are able to use a formula and manually edit a line item is when version scope is enabled in which you can specify which version is formula drive and which is a user input. But this does not seem relevant for you need.

Good luck, Chris

Quick Links

Can you help?

Unanswered questions

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…