Checklist with Icons

Question

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?

Answer 1

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.

Answer 2

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">

    $('#Checkbox').click(function(){
        var checked_status = this.checked;
        if(checked_status == true) {
            $('#txt').show();
        }
        else { $('#txt').hide();
        }
    }); </script>