Color cells or rows that were changed since base load date

PrevContributor

Hi, is there a possibility in Anaplan  module or in a list to color cells or rows that were changed since base load date??

PrevContributor

Hi,

There is a way to track changes since a given point in time.  Let me walk you through how I would build out a solution.

 
STEPS:
 
1.) Create a duplicate module of the existing module:

•  Note: You can pull the values over from the original module by linking the duplicate module to it and then deleting the formula. This will provide us with a control data set to compare changes against.
  

2.) Add a line item to the original module that compares the two data sets and will act as our trigger for conditional formatting
            a.) The formula would resemble this:  IF ORIGINAL MODULE <> DUPLICATE MODULE THEN 1 ELSE 0
 
3.) Apply conditional formatting logic to the original module.


I've also attached an example.

Regards,
Ryan