I have a SharePoint 2010 BI Requirement.

I have a custom checklist with over 100 columns. Each item (column) in the list has a status of either complete or incomplete. The default value is incomplete. There will be only 8-12 rows. The title field will be the row identifier. Several of the items have steps that need to be completed in order for the entire item to be complete. In other words, sub-steps. So I have a calculated column that has an IF statement (if steps 1 through x are complete, then display complete in that column, otherwise incomplete).

Example: Checklist item 5 has three sub items. When all three have been completed, then item 5 displays complete.

What I need to do is show each of these columns as a graphic icon. Unfortunately, I cannot have that many calculated columns to produce this effect. See this.

I have worked with SharePoint Designer and the conditional formatting is painful!!! Plus it only works for one particular view. I need to be able to display the icons in different web part views.

Also, the client doesn't want to use the KPI list as that it only displays down the page and not across.

Since I am not a code writer, I am posting this for SharePoint Community to lend some assistance. Any takers?


2 Answers 2


I've used a dataview web part before to display my own KPI indicators (from _layouts/images) and percentages of completion of groups of items based on a parent item or piece of metadata. It wasn't too difficult to pull off, but it did get tricky at times.


Here you can use this script to catch the Check and Uncheck event of the checkbox and then show and hide the respective image tag based off that event.

    <script type="text/javascript">

        var checked_status = this.checked;
        if(checked_status == true) {
        else { $('#txt').hide();
    }); </script>
  • I am not sure how this helps answer the OP's question - what am I missing?
    – Ryan
    Oct 9, 2012 at 15:08
  • He simply wants to show an Icon next to a field. I am simply showing him how to modify the HTML to apply an IMG tag next to the Table. I can't give a complete solution because I don't have the code but he just needs to modify the HTML to his liking. Oct 9, 2012 at 15:13
  • She wants the icons on a View I believe and they should be dynamic depending on the 'check' status, not static.
    – Ryan
    Oct 9, 2012 at 15:30
  • Check out the updated answer Oct 9, 2012 at 15:42
  • Thats not going to work on a view - just a form. Even then it will only work on a custom form that has #Checkbox and #txt elements already setup so is only half an answer. Sorry if I am giving you a hard time - not picking on you I just don't see how this helps the OP.
    – Ryan
    Oct 9, 2012 at 15:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.