{"id":6951,"date":"2015-12-18T16:41:33","date_gmt":"2015-12-18T08:41:33","guid":{"rendered":"http:\/\/www.boostsolutions.com\/blog\/?p=6951"},"modified":"2023-07-31T11:38:13","modified_gmt":"2023-07-31T03:38:13","slug":"calculated-boost-field-use-cases","status":"publish","type":"post","link":"https:\/\/www.boostsolutions.com\/blog\/calculated-boost-field-use-cases\/","title":{"rendered":"Calculated Boost Field Use Cases"},"content":{"rendered":"<p>Calculated Boost Field is a field which enables you to do calculate based on other columns like SharePoint Calculated column. With Calculated Boost, you can design powerful formula and complete complicated calculation.<\/p>\n<p>Calculated Boost supports more column types than SharePoint OOTB calculated column, including People, Lookup, Note, ID, Content Type etc. Even better, you can use [Today], [Me] and [Now] variables in the formula.<\/p>\n<p>The following cases will demonstrate how to use Calculated Boost Field.<\/p>\n<p><strong>[Case 1]<\/strong><\/p>\n<p>Case list records the cases status, and there is a date field &#8220;Start date&#8221; in the list. I want to create field based on below condition.<\/p>\n<p>If end date is less than current date enter value &#8220;Done&#8221;.<\/p>\n<p>If end date is greater than current date enter value &#8220;Doing&#8221;.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-1.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6952\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-1.png\" alt=\"CBF-1\" width=\"624\" height=\"240\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-1.png 624w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-1-300x115.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>In the Calcuated Boost field, you can design the formula as this:<\/p>\n<p><em>if([End Date]&lt;=[Today],&#8221;Done&#8221;,&#8221;Doing&#8221;)<\/em><\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-2.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6953\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-2.png\" alt=\"CBF-2\" width=\"585\" height=\"385\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-2.png 585w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-2-300x197.png 300w\" sizes=\"(max-width: 585px) 100vw, 585px\" \/><\/a><\/p>\n<p><strong>[Case 2]<\/strong><\/p>\n<p>I have a Subscribers list which is recording the email addresses, and I want to extract the user name from the address. The email in column is like <a href=\"mailto:hans@gmail.com\">hans@gmail.com<\/a>, the user name should be hans.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-3.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6954\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-3.png\" alt=\"CBF-3\" width=\"503\" height=\"284\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-3.png 503w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-3-300x169.png 300w\" sizes=\"(max-width: 503px) 100vw, 503px\" \/><\/a><\/p>\n<p>In the Calcuated Boost field, design the formula as this:<\/p>\n<p><em>SubString([E-mail], 0, IndexOf([E-mail],&#8221;@&#8221;))<\/em><\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-4.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6955\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-4.png\" alt=\"CBF-4\" width=\"475\" height=\"266\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-4.png 475w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-4-300x168.png 300w\" sizes=\"(max-width: 475px) 100vw, 475px\" \/><\/a><\/p>\n<p><strong>[Case 3]<\/strong><\/p>\n<p>I have a project list which is recording the project status. I want to create a column to show percentage completed based on the End Date, current date and Start Date.<\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-5.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6956\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-5.png\" alt=\"CBF-5\" width=\"467\" height=\"293\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-5.png 467w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-5-300x188.png 300w\" sizes=\"(max-width: 467px) 100vw, 467px\" \/><\/a><\/p>\n<p>In the Calcuated Boost field, design the formula as this:<\/p>\n<p><em>DiffDays([Today],[Start Date])\/DiffDays([End Date],[Start Date])<\/em><\/p>\n<p><a href=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-6.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-6957\" src=\"http:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-6.png\" alt=\"CBF-6\" width=\"652\" height=\"438\" srcset=\"https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-6.png 652w, https:\/\/www.boostsolutions.com\/blog\/wp-content\/uploads\/2015\/12\/CBF-6-300x201.png 300w\" sizes=\"(max-width: 652px) 100vw, 652px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Calculated Boost Field is a field which enables you to do calculate based on other columns like SharePoint Calculated column. With Calculated Boost, you can design powerful formula and complete complicated calculation. Calculated Boost supports more column types than SharePoint OOTB calculated column, including People, Lookup, Note, ID, Content Type etc. Even better, you can [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1,347,480,481],"tags":[],"_links":{"self":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6951"}],"collection":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=6951"}],"version-history":[{"count":2,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6951\/revisions"}],"predecessor-version":[{"id":6959,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6951\/revisions\/6959"}],"wp:attachment":[{"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=6951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=6951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.boostsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=6951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}