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?