{"id":4035,"date":"2012-06-06T12:00:14","date_gmt":"2012-06-06T11:00:14","guid":{"rendered":"http:\/\/www.markwilson.co.uk\/blog\/?p=4035"},"modified":"2012-05-30T17:51:42","modified_gmt":"2012-05-30T16:51:42","slug":"calculated-value-based-on-todays-date-in-a-sharepoint-column","status":"publish","type":"post","link":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm","title":{"rendered":"Calculated value based on today&#8217;s date in a SharePoint column"},"content":{"rendered":"<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignright\" title=\"Calculated value in MOSS 2007, based on current date\" src=\"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/images\/sharepoint-review-date-calculated-value.png?resize=165%2C300&#038;ssl=1\" alt=\"\" width=\"165\" height=\"300\" \/>One of my current projects involves developing an internal system to keep track of the technologies that are approved for use in our solutions. \u00a0As part of that, I&#8217;d like to set a flag on each entry so that it is regularly reviewed &#8211; for example\u00a0every\u00a090, or 180 days.<\/p>\n<p>I had hoped to use a calculated column for this (i.e. today&#8217;s date plus <em>x<\/em> days) but it&#8217;s generally recognised that calculated fields only work on data entered by a user, and not from the system. Indeed, <a href=\"http:\/\/office.microsoft.com\/en-us\/windows-sharepoint-services-help\/today-function-HA001161087.aspx\">Microsoft&#8217;s own documentation for the TODAY function<\/a> says:<\/p>\n<blockquote cite=\"http:\/\/office.microsoft.com\/en-us\/windows-sharepoint-services-help\/today-function-HA001161087.aspx\"><p>&#8220;[&#8230;]\u00a0You can use the TODAY function only as a default value; you cannot use it in a calculated column.&#8221;<\/p><\/blockquote>\n<p>Even so, I&#8217;ve had some success (with Microsoft Office SharePoint Server 2007) in setting a column type of Date and Time, in Date Only format, with a Calculated Value of <code>=Today+90<\/code>. \u00a0I&#8217;m not sure how\/why this is working, given Microsoft&#8217;s statement above, but it may be worth considering. \u00a0Just be aware that your mileage may vary&#8230;<\/p>\n<p>(<a href=\"http:\/\/blog.pathtosharepoint.com\/2008\/08\/14\/calculated-columns-the-useless-today-trick\/\">Christophe Humbert has more information and another approach over at Path to SharePoint<\/a>)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of my current projects involves developing an internal system to keep track of the technologies that are approved for use in our solutions. \u00a0As part of that, I&#8217;d like to set a flag on each entry so that it is regularly reviewed &#8211; for example\u00a0every\u00a090, or 180 days. I had hoped to use a &hellip; <a href=\"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Calculated value based on today&#8217;s date in a SharePoint column<\/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],"class_list":["post-4035","post","type-post","status-publish","format-standard","hentry","category-technology","tag-sharepoint"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Calculated value based on today&#039;s date in a SharePoint column - 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\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Calculated value based on today&#039;s date in a SharePoint column - markwilson.it\" \/>\n<meta property=\"og:description\" content=\"One of my current projects involves developing an internal system to keep track of the technologies that are approved for use in our solutions. \u00a0As part of that, I&#8217;d like to set a flag on each entry so that it is regularly reviewed &#8211; for example\u00a0every\u00a090, or 180 days. I had hoped to use a &hellip; Continue reading Calculated value based on today&#8217;s date in a SharePoint column\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm\" \/>\n<meta property=\"og:site_name\" content=\"markwilson.it\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-06T11:00:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.markwilson.co.uk\/blog\/images\/sharepoint-review-date-calculated-value.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\\\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm\"},\"author\":{\"name\":\"Mark Wilson\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"headline\":\"Calculated value based on today&#8217;s date in a SharePoint column\",\"datePublished\":\"2012-06-06T11:00:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm\"},\"wordCount\":200,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/sharepoint-review-date-calculated-value.png\",\"keywords\":[\"Microsoft SharePoint\"],\"articleSection\":[\"Technology\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm\",\"name\":\"Calculated value based on today's date in a SharePoint column - markwilson.it\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/sharepoint-review-date-calculated-value.png\",\"datePublished\":\"2012-06-06T11:00:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm#primaryimage\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/sharepoint-review-date-calculated-value.png\",\"contentUrl\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/images\\\/sharepoint-review-date-calculated-value.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2012\\\/06\\\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Calculated value based on today&#8217;s date in a SharePoint column\"}]},{\"@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":"Calculated value based on today's date in a SharePoint column - 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\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm","og_locale":"en_GB","og_type":"article","og_title":"Calculated value based on today's date in a SharePoint column - markwilson.it","og_description":"One of my current projects involves developing an internal system to keep track of the technologies that are approved for use in our solutions. \u00a0As part of that, I&#8217;d like to set a flag on each entry so that it is regularly reviewed &#8211; for example\u00a0every\u00a090, or 180 days. I had hoped to use a &hellip; Continue reading Calculated value based on today&#8217;s date in a SharePoint column","og_url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm","og_site_name":"markwilson.it","article_published_time":"2012-06-06T11:00:14+00:00","og_image":[{"url":"https:\/\/www.markwilson.co.uk\/blog\/images\/sharepoint-review-date-calculated-value.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\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm#article","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm"},"author":{"name":"Mark Wilson","@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"headline":"Calculated value based on today&#8217;s date in a SharePoint column","datePublished":"2012-06-06T11:00:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm"},"wordCount":200,"commentCount":0,"publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/sharepoint-review-date-calculated-value.png","keywords":["Microsoft SharePoint"],"articleSection":["Technology"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm","url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm","name":"Calculated value based on today's date in a SharePoint column - markwilson.it","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm#primaryimage"},"image":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm#primaryimage"},"thumbnailUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/sharepoint-review-date-calculated-value.png","datePublished":"2012-06-06T11:00:14+00:00","breadcrumb":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm#primaryimage","url":"https:\/\/www.markwilson.co.uk\/blog\/images\/sharepoint-review-date-calculated-value.png","contentUrl":"https:\/\/www.markwilson.co.uk\/blog\/images\/sharepoint-review-date-calculated-value.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/calculated-value-based-on-todays-date-in-a-sharepoint-column.htm#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.markwilson.co.uk\/blog"},{"@type":"ListItem","position":2,"name":"Calculated value based on today&#8217;s date in a SharePoint column"}]},{"@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":4209,"url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/08\/creating-a-sharepoint-calculated-column-that-uses-information-from-a-lookup-column.htm","url_meta":{"origin":4035,"position":0},"title":"Creating a SharePoint calculated column that uses information from a lookup column","author":"Mark Wilson","date":"Thursday 2 August 2012","format":false,"excerpt":"A few months ago, Klout suggested I knew something about SharePoint. I laughed at the time but the last few weeks have seen me spending far more time working on a couple of SharePoint-based systems than I would like, so maybe Klout is less of a measure of social influence\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-workflow-lookup-plaintext.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":4653,"url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/12\/sharepoint-datasheet-mode-crashes-internet-explorer.htm","url_meta":{"origin":4035,"position":1},"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":5649,"url":"https:\/\/www.markwilson.co.uk\/blog\/2015\/05\/short-takes-symbols-in-office-applications-and-converting-numbers-to-text-in-excel.htm","url_meta":{"origin":4035,"position":2},"title":"Short takes: Symbols in Office applications and converting numbers to text in Excel","author":"Mark Wilson","date":"Sunday 17 May 2015","format":false,"excerpt":"A few snippets I found on scraps of paper whilst sorting\u00a0out my office this\u00a0week... Shortcuts to\u00a0symbols in Office applications Many people will be familiar with typing (c) to generate a \u00a9 symbol in Microsoft Office applications but you can also use (R) or (TM) for trademark symbols \u00ae and \u2122.\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":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":4035,"position":3},"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":3915,"url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/05\/more-sharepoint-shenanigans.htm","url_meta":{"origin":4035,"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 &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":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":4035,"position":5},"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":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/4035","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=4035"}],"version-history":[{"count":5,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/4035\/revisions"}],"predecessor-version":[{"id":4074,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/4035\/revisions\/4074"}],"wp:attachment":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=4035"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=4035"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=4035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}