{"id":4056,"date":"2012-06-14T12:00:40","date_gmt":"2012-06-14T11:00:40","guid":{"rendered":"http:\/\/www.markwilson.co.uk\/blog\/?p=4056"},"modified":"2012-12-07T19:45:37","modified_gmt":"2012-12-07T19:45:37","slug":"creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress","status":"publish","type":"post","link":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm","title":{"rendered":"Creating a dashboard using a SharePoint list (part 3): indicating several states of progress"},"content":{"rendered":"

Yesterday’s post looked at using ticks\/crosses on my SharePoint dashboard<\/a> 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.<\/p>\n

We settled on a system using a series of circles with various stages of “filling-in” (none, quarter, half, three-quarters, full) to show how far an activity had progressed, and I amended the code that I used for the ticks and crosses.<\/p>\n

Using the same principle as with the ticks and crosses, this time the font changed from Wingdings to Arial Unicode MS, which includes the appropriate shapes under the block elements and geometric shapes subrange:<\/p>\n

\"\"<\/p>\n

First of all, I changed my column to indicate progress from a Yes\/No to a Choice with radio buttons for Not Started; Started; Additional Information Required; Almost Complete; Complete and Not Applicable.<\/p>\n

Next I needed to adapt the formula used to calculate the correct HTML code for the display column by nesting repeated iterations of <\/p>\n

IF([Task Progress]=”Started”,”

?<\/DIV>“,”
?<\/DIV>“)<\/dirtycode><\/p>\n

Eventually this ended up as:<\/p>\n

=IF([Task Progress]=”Complete”,”

?<\/DIV>“,IF([Task Progress]=”Started”,”
?<\/DIV>“,IF([Task Progress]=”Additional Information Required”,”
?<\/DIV>“,IF([Task Progress]=”Almost Complete”,”
?<\/DIV>“,IF([Task Progress]=”Not Applicable”,”
<\/DIV>“,”
?<\/DIV>“)))))<\/dirtycode><\/p>\n

The code is not pretty, but it seems to work, and the result is something like this:<\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

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 using a series of circles … Continue reading Creating a dashboard using a SharePoint list (part 3): indicating several states of progress<\/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-4056","post","type-post","status-publish","format-standard","hentry","category-technology","tag-sharepoint","tag-website-development"],"yoast_head":"\nCreating a dashboard using a SharePoint list (part 3): indicating several states of progress - 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-3-indicating-several-states-of-progress.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 3): indicating several states of progress - markwilson.it\" \/>\n<meta property=\"og:description\" content=\"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 using a series of circles … Continue reading Creating a dashboard using a SharePoint list (part 3): indicating several states of progress\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm\" \/>\n<meta property=\"og:site_name\" content=\"markwilson.it\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-14T11:00:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2012-12-07T19:45:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.markwilson.co.uk\/blog\/images\/arial-unicode-ms-circles.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-3-indicating-several-states-of-progress.htm#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm\"},\"author\":{\"name\":\"Mark Wilson\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"headline\":\"Creating a dashboard using a SharePoint list (part 3): indicating several states of progress\",\"datePublished\":\"2012-06-14T11:00:40+00:00\",\"dateModified\":\"2012-12-07T19:45:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm\"},\"wordCount\":242,\"commentCount\":0,\"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-3-indicating-several-states-of-progress.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/arial-unicode-ms-circles.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-3-indicating-several-states-of-progress.htm#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm\",\"name\":\"Creating a dashboard using a SharePoint list (part 3): indicating several states of progress - 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-3-indicating-several-states-of-progress.htm#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/arial-unicode-ms-circles.png\",\"datePublished\":\"2012-06-14T11:00:40+00:00\",\"dateModified\":\"2012-12-07T19:45:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm#primaryimage\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/arial-unicode-ms-circles.png\",\"contentUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/arial-unicode-ms-circles.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.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 3): indicating several states of progress\"}]},{\"@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 > \\\/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 3): indicating several states of progress - 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-3-indicating-several-states-of-progress.htm","og_locale":"en_GB","og_type":"article","og_title":"Creating a dashboard using a SharePoint list (part 3): indicating several states of progress - markwilson.it","og_description":"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 using a series of circles … Continue reading Creating a dashboard using a SharePoint list (part 3): indicating several states of progress","og_url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm","og_site_name":"markwilson.it","article_published_time":"2012-06-14T11:00:40+00:00","article_modified_time":"2012-12-07T19:45:37+00:00","og_image":[{"url":"https:\/\/www.markwilson.co.uk\/blog\/images\/arial-unicode-ms-circles.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-3-indicating-several-states-of-progress.htm#article","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm"},"author":{"name":"Mark Wilson","@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"headline":"Creating a dashboard using a SharePoint list (part 3): indicating several states of progress","datePublished":"2012-06-14T11:00:40+00:00","dateModified":"2012-12-07T19:45:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm"},"wordCount":242,"commentCount":0,"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-3-indicating-several-states-of-progress.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/arial-unicode-ms-circles.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-3-indicating-several-states-of-progress.htm#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm","url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm","name":"Creating a dashboard using a SharePoint list (part 3): indicating several states of progress - 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-3-indicating-several-states-of-progress.htm#primaryimage"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/arial-unicode-ms-circles.png","datePublished":"2012-06-14T11:00:40+00:00","dateModified":"2012-12-07T19:45:37+00:00","breadcrumb":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.htm#primaryimage","url":"https:\/\/www.markwilson.co.uk\/blog\/images\/arial-unicode-ms-circles.png","contentUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/arial-unicode-ms-circles.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-3-indicating-several-states-of-progress.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 3): indicating several states of progress"}]},{"@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 > \/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":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":4056,"position":0},"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 "Technology"","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4049,"url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-2-tickcross-status-indicators.htm","url_meta":{"origin":4056,"position":1},"title":"Creating a dashboard using a SharePoint list (part 2): tick\/cross status indicators","author":"Mark Wilson","date":"Wednesday 13 June 2012","format":false,"excerpt":"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\u2026","rel":"","context":"In "Technology"","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\/tick-cross.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"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":4056,"position":2},"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 "Technology"","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":7385,"url":"https:\/\/www.markwilson.co.uk\/blog\/2018\/02\/weeknote-9-sharepoint-cms-little-power-bi-help-visualise-dynamic-data-week-6-2018.htm","url_meta":{"origin":4056,"position":3},"title":"Weeknote 9: SharePoint as a CMS, with a little Power BI to help visualise dynamic data (Week 6, 2018)","author":"Mark Wilson","date":"Saturday 10 February 2018","format":false,"excerpt":"2018 is flying by but the last couple of weeks have been exciting. After a period of working on short-term engagements (which can be a challenge at times), I've landed myself a gig on a decent sized Modern Workplace project that's going to keep me (and a lot of other\u2026","rel":"","context":"In "Technology"","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":4056,"position":4},"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 "Technology"","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":4056,"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 "Technology"","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\/4056","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=4056"}],"version-history":[{"count":12,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/4056\/revisions"}],"predecessor-version":[{"id":4652,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/4056\/revisions\/4652"}],"wp:attachment":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=4056"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=4056"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=4056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}