Colour in Sims Assessment – Individual Reports

BySarah Hart

When adding colours within a cell in a marksheet, (right clicking on the cell “Select colour to a cell”)  the colour will NOT pull into individual reports.  If you want the colour to pull into an individual report along with the result, it will need to be coloured using a Nested If Then Else formula…

How do I use the nested If Then Else formula?

BySarah Hart

The nested If Then Else formula needs to be followed as below to ensure that expected results are shown. To create a nested If Then Else formula, you first need to include in the Template the column(s) you wish to compare. Example: Template name: English Targets – Year 6 Aspect: English Achieved | Result Set:…