+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, Traffic Light Colour in SIMS Assessment Manager - can't get rid of it in Technical; Hi! I'm sorry if this is posted anywhere else on edugeek, i did search but couldnt find an answer. I'm ...
  1. #1
    LianneKemp's Avatar
    Join Date
    Apr 2012
    Location
    Solihull
    Posts
    20
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Traffic Light Colour in SIMS Assessment Manager - can't get rid of it

    Hi!
    I'm sorry if this is posted anywhere else on edugeek, i did search but couldnt find an answer. I'm creating a tracking sheet in SIMS Assessment Manager, and one of my columns (where the forumla was MAX) was being shaded red for no reason. I checked all the Nested if Then Else formulas and it wasnt using that column so I couldnt see why it was coloured in. I tried deleting all my Traffic Light formulas from my marksheet template but this is still pulling through all of the traffic light colours on the marksheet.
    Is there a way of getting rid of the traffic light colours or do I need to start again?
    Thanks!!!
    Lianne

  2. #2

    Join Date
    Sep 2006
    Location
    Reading
    Posts
    177
    Thank Post
    14
    Thanked 41 Times in 39 Posts
    Rep Power
    23
    It may be that the column is being coloured in another mark sheet.

  3. #3
    LianneKemp's Avatar
    Join Date
    Apr 2012
    Location
    Solihull
    Posts
    20
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I've checked and there isn't anywhere else that this would be coloured from - I have set up the aspects for my marksheet from scratch so they wouldn't used be anywhere else.

  4. #4

    Join Date
    Jan 2013
    Posts
    3
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Have you tried right clicking on the column heading and clear column colour?

  5. Thanks to andyh46 from:

    LianneKemp (29th May 2013)

  6. #5

    Join Date
    Mar 2012
    Posts
    18
    Thank Post
    3
    Thanked 6 Times in 4 Posts
    Rep Power
    6
    I had this some time ago, and although it was a bit of a faff I'm sure I found that if I created a nested if then else for if 1 = 1 then blank (selecting no colour) and apply that to the column in question (through Also colour this column), calculating will remove the colour. That formula column can then be deleted.
    Hopefully that should successfully get rid of your colour.
    If it doesn't, it must be picking up a colour from another template.

  7. Thanks to HannahBuist from:

    LianneKemp (29th May 2013)

  8. #6
    LianneKemp's Avatar
    Join Date
    Apr 2012
    Location
    Solihull
    Posts
    20
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    right clicking and clear colour didn't work as that option was greyed out but thank you

    creating a nested if then else formula worked, thank you

  9. #7
    LianneKemp's Avatar
    Join Date
    Apr 2012
    Location
    Solihull
    Posts
    20
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi, I don't suppose any one knows how to clear data generated by a formula in a marksheet do you? I currently have data that has calculated from somewhere but it shouldn't be there. Thanks!

  10. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    If it's in an aspect, you can't clear aspects. It won't save and will revert to the old value.
    You'd have to use the tools to delete results which works well but is scary.

  11. Thanks to vikpaw from:

    LianneKemp (7th June 2013)

  12. #9
    LianneKemp's Avatar
    Join Date
    Apr 2012
    Location
    Solihull
    Posts
    20
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks vikpaw, my local helpdesk were on the phone and talked me through deleting the results just as you replied! thanks again

  13. #10

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Just be sure to track the source of the issue. It seems you've got columns that appear on marksheets elsewhere and are picking up calculations and colours etc. If you don't find out where, there's nothing to stop it happening again.
    If it's at the end of a marksheet that someone else is updating even if it's a different column, if it auto calculates you'll keep getting it back again.
    Hopefully it's just old data that shouldn't recur but be careful.
    It's useful to right click and view result - i think that's possible on a formula column too, and check the date and who entered it.

  14. Thanks to vikpaw from:

    LianneKemp (7th June 2013)

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Sims Assessment Manager Individual Reports
    By MACIT in forum MIS Systems
    Replies: 11
    Last Post: 30th June 2011, 02:14 PM
  2. Replies: 3
    Last Post: 13th April 2011, 09:03 AM
  3. Missing marks in Sims Assessment Manager
    By MACIT in forum MIS Systems
    Replies: 16
    Last Post: 9th February 2010, 05:29 AM
  4. [CLOSED] Misc: Can we get rid of Chat notice now please
    By SimpleSi in forum EduGeek.net Site Problems
    Replies: 3
    Last Post: 12th March 2008, 08:38 AM
  5. Sims Assessment Manager Performance Issues
    By barryfl in forum MIS Systems
    Replies: 4
    Last Post: 14th March 2006, 11:52 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •