KPI to show your list status based on single line text column

For quickshot analysis of your SharePoint lists, you can add images to your lists so as to check what status is your item in. This is applicable for workflows checking, gender, approved/rejected items, really, anything you can think of and use for your business requirement. Here is how you do it, aka., how I did it. 🙂 Use at your own risk or fun.

• Add a Calculated column to your SharePoint list and call it KPI(call it anything you want, I just like the name KPI as it sounds cool and stands for ‘Key Performance Indicator’)
• Add the script below in the formula section:
  =”<center>”&IF(WFStatus=”ParentWFDone”,”<imgsrc=’https://l1org.sharepoint.com/sites/TS/_layouts/images/kpidefault-0.gif’border=’0’/>&#8221;,IF(WFStatus=”New”,”<img

  src=’https://lo1rg.sharepoint.com/sites/TS/SiteAssets/Images/newItem.png&#8217;

  border=’0’/>”,IF(WFStatus=”InProgress”,”<img

  src=’https://lo1rg.sharepoint.com/sites/TS/_layouts/images/kpidefault-1.gif&#8217;

  border=’0’/>”,IF(WFStatus=”Rejected”,”<img

  src=’https://lo1rg.sharepoint.com/sites/TS/_layouts/images/kpidefault-2.gif&#8217;

  border=’0’/>”,””)))&”</center>”)

As seen in the picture below:

Formula is pretty self-explanatory isn’t it?
Center the KPI image from a hyperlink location, if your text column says ‘New’/’InProgress’/’Rejected’ change the image in the KPI column from your image library hyperlinked image.

That’s the gist of it.

If external sharing is enabled in your tenant, that would possibly mean you can knock your self and your sites out with all sorts of smileys from Bing/google search. If its not, then you MUST add the images you wish to link to the KPI column to an accessible site where viewers have at least ‘View’ rights (interesting isn’t it, viewers MUST have ‘view’ rights duh!)
Well, I like adding my Images folder into my SharePoint Site Assets (Site contents > Site Assets > Images) Cleaner that way and manageable.
Once the images are in place and your calculated column tied to a Single Line of Text column in your SharePoint List

Based on the formula defined, your list will now show KPI images!

Enjoy!

Share this post: on Twitter on LinkedIn