{"id":4049,"date":"2012-06-13T12:00:20","date_gmt":"2012-06-13T11:00:20","guid":{"rendered":"http:\/\/www.markwilson.co.uk\/blog\/?p=4049"},"modified":"2012-05-30T16:47:47","modified_gmt":"2012-05-30T15:47:47","slug":"creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators","status":"publish","type":"post","link":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm","title":{"rendered":"Creating a dashboard using a SharePoint list (part 2): tick\/cross status indicators"},"content":{"rendered":"<p>In my last post, I wrote about how <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-1-colour-coded-status-indicators.htm\">I used a script I found on the Internet and a couple of calculated columns to show a Red\/Amber\/Green (RAG) status on a list in SharePoint<\/a>. I also wanted to clearly indicate which items in my list were complete, and which were still ongoing.<\/p>\n<p>My inspiration for this came from <a href=\"http:\/\/doogalbellend.blogspot.co.uk\/2007\/09\/yet-more-tick-mark-fun.html\">Chris Bell&#8217;s posts on displaying tick marks in HTML<\/a>, combined with the same code that converts my text RAG Status to HTML.<\/p>\n<p>This time, I converted a Yes\/No Checkbox (<a href=\"https:\/\/www.markwilson.co.uk\/blog\/2012\/05\/more-sharepoint-shenanigans.htm\">actually, it&#8217;s TRUE\/FALSE<\/a>) to HTML code for a tick or a cross in another column, using the following formula:<\/p>\n<p><dirtycode:noclick>=IF([Task Completed]=TRUE,&#8221;<DIV style='font-family:Wingdings; font-weight:bold; font-size:24px; color:green'>\u00fc<\/DIV>&#8220;,&#8221;<DIV style='font-family:Wingdings; font-weight:bold; font-size:24px; color:gray;'>\u00fb<\/DIV>&#8220;)<\/dirtycode><\/p>\n<p>The end result is something like this:<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" alt=\"\" src=\"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/images\/tick-cross.png?resize=52%2C24&#038;ssl=1\" title=\"Tick\/cross from the Wingdings font, with some in-line styling applied\" class=\"alignnone\" width=\"52\" height=\"24\" \/><\/p>\n<p>It needs the Wingdings font to be installed, but everyone who needs to access this list is using a Windows PC &#8211; feels like a bit of a fudge but it works for now&#8230; and can always be replaced with a graphic (as I did for the KPI indicators on the RAG status).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In my last post, I wrote about how I used a script I found on the Internet and a couple of calculated columns to show a Red\/Amber\/Green (RAG) status on a list in SharePoint. I also wanted to clearly indicate which items in my list were complete, and which were still ongoing. My inspiration for &hellip; <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Creating a dashboard using a SharePoint list (part 2): tick\/cross status indicators<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[218],"tags":[93,29],"class_list":["post-4049","post","type-post","status-publish","format-standard","hentry","category-technology","tag-sharepoint","tag-website-development"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Creating a dashboard using a SharePoint list (part 2): tick\/cross status indicators - markwilson.it<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating a dashboard using a SharePoint list (part 2): tick\/cross status indicators - markwilson.it\" \/>\n<meta property=\"og:description\" content=\"In my last post, I wrote about how I used a script I found on the Internet and a couple of calculated columns to show a Red\/Amber\/Green (RAG) status on a list in SharePoint. I also wanted to clearly indicate which items in my list were complete, and which were still ongoing. My inspiration for &hellip; Continue reading Creating a dashboard using a SharePoint list (part 2): tick\/cross status indicators\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm\" \/>\n<meta property=\"og:site_name\" content=\"markwilson.it\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-13T11:00:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.markwilson.co.uk\/blog\/images\/tick-cross.png\" \/>\n<meta name=\"author\" content=\"Mark Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@markwilsonit\" \/>\n<meta name=\"twitter:site\" content=\"@markwilsonit\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mark Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm\"},\"author\":{\"name\":\"Mark Wilson\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"headline\":\"Creating a dashboard using a SharePoint list (part 2): tick\\\/cross status indicators\",\"datePublished\":\"2012-06-13T11:00:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm\"},\"wordCount\":188,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/tick-cross.png\",\"keywords\":[\"Microsoft SharePoint\",\"Website Development\"],\"articleSection\":[\"Technology\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm\",\"name\":\"Creating a dashboard using a SharePoint list (part 2): tick\\\/cross status indicators - markwilson.it\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/tick-cross.png\",\"datePublished\":\"2012-06-13T11:00:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm#primaryimage\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/tick-cross.png\",\"contentUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/tick-cross.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating a dashboard using a SharePoint list (part 2): tick\\\/cross status indicators\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/\",\"name\":\"markwilson.it\",\"description\":\"get-info -class technology | write-output &gt; \\\/dev\\\/web\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\",\"name\":\"Mark Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"width\":800,\"height\":800,\"caption\":\"Mark Wilson\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\"},\"description\":\"A Chartered IT Professional, with recent experience in technology leadership, IT strategy and practice management roles, Mark Wilson is an Enterprise Architect in the Advisory and Management Group at risual. During a career spanning more than two decades, Mark has gained widespread recognition as an expert in his field including both industry and national press exposure. In addition to certifications from Microsoft, VMware, Red Hat, The Open Group and Axelos, Mark held a Microsoft Most Valuable Professional (MVP) award for three years and is now part of the MVP Reconnect programme. Mark is also well-known on social media and maintains an award-winning blog.\",\"sameAs\":[\"http:\\\/\\\/www.markwilson.co.uk\\\/\",\"https:\\\/\\\/www.instagram.com\\\/markwilsonuk\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/markawilson\\\/\",\"https:\\\/\\\/x.com\\\/markwilsonit\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCWHlZCoHRTocdvtrOJ2IL4A\"],\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/author\\\/mark-wilson\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating a dashboard using a SharePoint list (part 2): tick\/cross status indicators - markwilson.it","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm","og_locale":"en_GB","og_type":"article","og_title":"Creating a dashboard using a SharePoint list (part 2): tick\/cross status indicators - markwilson.it","og_description":"In my last post, I wrote about how I used a script I found on the Internet and a couple of calculated columns to show a Red\/Amber\/Green (RAG) status on a list in SharePoint. I also wanted to clearly indicate which items in my list were complete, and which were still ongoing. My inspiration for &hellip; Continue reading Creating a dashboard using a SharePoint list (part 2): tick\/cross status indicators","og_url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm","og_site_name":"markwilson.it","article_published_time":"2012-06-13T11:00:20+00:00","og_image":[{"url":"https:\/\/www.markwilson.co.uk\/blog\/images\/tick-cross.png","type":"","width":"","height":""}],"author":"Mark Wilson","twitter_card":"summary_large_image","twitter_creator":"@markwilsonit","twitter_site":"@markwilsonit","twitter_misc":{"Written by":"Mark Wilson","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm#article","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm"},"author":{"name":"Mark Wilson","@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"headline":"Creating a dashboard using a SharePoint list (part 2): tick\/cross status indicators","datePublished":"2012-06-13T11:00:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm"},"wordCount":188,"commentCount":1,"publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/tick-cross.png","keywords":["Microsoft SharePoint","Website Development"],"articleSection":["Technology"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm","url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm","name":"Creating a dashboard using a SharePoint list (part 2): tick\/cross status indicators - markwilson.it","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm#primaryimage"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/tick-cross.png","datePublished":"2012-06-13T11:00:20+00:00","breadcrumb":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm#primaryimage","url":"https:\/\/www.markwilson.co.uk\/blog\/images\/tick-cross.png","contentUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/tick-cross.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.markwilson.co.uk\/blog"},{"@type":"ListItem","position":2,"name":"Creating a dashboard using a SharePoint list (part 2): tick\/cross status indicators"}]},{"@type":"WebSite","@id":"https:\/\/www.markwilson.co.uk\/blog\/#website","url":"https:\/\/www.markwilson.co.uk\/blog\/","name":"markwilson.it","description":"get-info -class technology | write-output &gt; \/dev\/web","publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.markwilson.co.uk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468","name":"Mark Wilson","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","url":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","width":800,"height":800,"caption":"Mark Wilson"},"logo":{"@id":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1"},"description":"A Chartered IT Professional, with recent experience in technology leadership, IT strategy and practice management roles, Mark Wilson is an Enterprise Architect in the Advisory and Management Group at risual. During a career spanning more than two decades, Mark has gained widespread recognition as an expert in his field including both industry and national press exposure. In addition to certifications from Microsoft, VMware, Red Hat, The Open Group and Axelos, Mark held a Microsoft Most Valuable Professional (MVP) award for three years and is now part of the MVP Reconnect programme. Mark is also well-known on social media and maintains an award-winning blog.","sameAs":["http:\/\/www.markwilson.co.uk\/","https:\/\/www.instagram.com\/markwilsonuk\/","https:\/\/www.linkedin.com\/in\/markawilson\/","https:\/\/x.com\/markwilsonit","https:\/\/www.youtube.com\/channel\/UCWHlZCoHRTocdvtrOJ2IL4A"],"url":"https:\/\/www.markwilson.co.uk\/blog\/author\/mark-wilson"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":4043,"url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-1-colour-coded-status-indicators.htm","url_meta":{"origin":4049,"position":0},"title":"Creating a dashboard using a SharePoint list (part 1): colour coded status indicators","author":"Mark Wilson","date":"Tuesday 12 June 2012","format":false,"excerpt":"I've been having some fun over the last couple of weeks, developing a dashboard in SharePoint to track a number of activities that I'm co-ordinating. Within our company there are some people who criticise SharePoint as a platform, largely because of some of the confusing messaging around some of the\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/images\/sharepoint-kpidefault-0.gif?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":4056,"url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm","url_meta":{"origin":4049,"position":1},"title":"Creating a dashboard using a SharePoint list (part 3): indicating several states of progress","author":"Mark Wilson","date":"Thursday 14 June 2012","format":false,"excerpt":"Yesterday's post looked at using ticks\/crosses on my SharePoint dashboard to track progress on activities. I was quite happy with this, but my manager wanted to show progress, rather than a simple binary done\/not done - and I wanted it to be visual, not text-based. We settled on a system\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/images\/status-circles.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":4066,"url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-a-sharepoint-list-part-4-bringing-it-all-together.htm","url_meta":{"origin":4049,"position":2},"title":"Creating a dashboard using a SharePoint list (part 4): bringing it all together","author":"Mark Wilson","date":"Friday 15 June 2012","format":false,"excerpt":"This week has been a bit of a SharePoint-fest as I've walked through the stages of creating my SharePoint dashboard. For obvious reasons, I can't share the version I use at work, so I've created a mockup using the SharePoint site that comes with my Office 365 subscription. Feel free\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3915,"url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/05\/more-sharepoint-shenanigans.htm","url_meta":{"origin":4049,"position":3},"title":"More SharePoint shenanigans","author":"Mark Wilson","date":"Friday 18 May 2012","format":false,"excerpt":"This week, I'ave mostly been working in SharePoint (those of a certain age may spot the reference to\u00a0Jesse from the Fast Show?) Earlier this month, I wrote a post with a few hints and tips I'd picked up whilst developing a site based on SharePoint. \u00a0Since then, I've come up\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4653,"url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/12\/sharepoint-datasheet-mode-crashes-internet-explorer.htm","url_meta":{"origin":4049,"position":4},"title":"SharePoint datasheet mode crashes Internet Explorer","author":"Mark Wilson","date":"Friday 7 December 2012","format":false,"excerpt":"Back in the summer I wrote about creating dashboards in SharePoint using some borrowed JavaScript in a webpart to display calculate columns of HTML. \u00a0I needed to create another dashboard recently, so I reused my old technique but then, today, I found that I could no longer edit my list\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4688,"url":"https:\/\/www.markwilson.co.uk\/blog\/2013\/01\/internet-explorer-crashes-when-editing-lists-in-sharepoint-datasheet-view.htm","url_meta":{"origin":4049,"position":5},"title":"Internet Explorer crashes when editing lists in SharePoint datasheet view","author":"Mark Wilson","date":"Thursday 3 January 2013","format":false,"excerpt":"Recently, I found I was experiencing issues when editing lists in SharePoint. \u00a0After switching to datasheet view, Internet Explorer displayed a message which said: Internet Explorer has stopped working Windows is checking for a solution to the problem... then: A problem caused the program to stop working correctly. Windows will\u2026","rel":"","context":"In &quot;Technology&quot;","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/images\/ie-dep.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/4049","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=4049"}],"version-history":[{"count":7,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/4049\/revisions"}],"predecessor-version":[{"id":4068,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/4049\/revisions\/4068"}],"wp:attachment":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=4049"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=4049"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=4049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}