[sims] Templates - if then else formula colours carrying over into separate templates?

[JoeS]

I created a historic template last year which colours in cells in a column based on a nested if then else formula.

 

Now I have come to create a totally different template, which just so happens to use one of the same aspects as in the historic template, and for some reason the colours I applied in the historic template are still appearing in the cells for this aspect??

 

Why is this happening, and can I get rid of this colouring?

 

Many thanks,

[JoeS]

After a bit of research it seems like this is expected behaviour from SIMS?!

 

If I create a template with a nested if then else formula review column, that colours cells in the formula column - and then ends with "Also colour this column" (with aspect column name).... Apparently this then permanently staples the colour to the results in that aspect/results set. So if I want to used that aspect/results set in a totally separate template months later, and this time I don't want those results to be coloured in (because they are not the focus of this new template), there is nothing I can do as that colour is now permanently baked into the results?

 

Is there a way to either colour results in a column in a non permanent way? Or is there a way to easily clear the colours in a load of columns? (without having to make them all non-read only and then selecting each column manually and right clicking "clear column colour"??)

 

This seems like a mad way for SIMS to behave? Why would I want a result to permanently be a certain colour? What if I want to used that result in another template where the colour should not be there?