How to color a cell depending on boolean conditions ?

Hi I would like to know how to color a boolean cell depending on a condition. Do you know where we can do this (UX, module etc) and what formula we should put ?

- in green : the node is already created and unchanged

- in yellow : the node is already created but changed

- in red : the node is not created yet

A lot of thanks !!

Accepted answers

All comments

KirillKuznetsov

@johannadreano

Any color formatting is based on numbered formatted line item. So to achieve what you want you have to create this line item. It has to be in the same module where you want to apply the CF.

If you want to check whether anything has been changed you have to have the duplicates of the line items which are supposed to be criterias of the changes. In these duplicates you would store the submitted values which should be imported from the input. This way you would get "before" and "after" values which (when compared and combined) will define the value for color formatting.

ankit_cheeni

Hi @johannadreano

That is a good questions and I remember it confused me for a long time on where to make the changes. I will try to answer your question in points

We call 'coloring of cells' conditional formatting in Anaplan
You need a number formatted line item to set CF. You need a minimum of two numbers and max 3 and assign colors to the numbers. Basis your selection, you get the cells colored (either step wise or within a spectrum).
You can do it within a module in a saved view (usually not recommended) or you can do it directly on the NUX (this has more color/type options)

In your case, you'd need to create a number formatted line item in your module, the formula would be something like: IF 'the node is already created and unchanged' THEN -1 ELSE IF 'the node is already created but changed' THEN 0 ELSE 1. By doing this, we have given 3 numbers to ourselves (-1, 0 and 1).

Then you go to NUX and create the view you want to publish. You'll see this option:

Click on the line item you want to use CF on, and then click this option. Rest is pretty straight forward, you select the number formatted line item that will drive your CF and select the colors against each number:

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…