Category Archives: CalculatedColumn

Calculating Working Hours – days in first week

  …this post was published on 2016 March 31. Let’s start with the beginning. And because an image it’s like 1000 words: The user filled the start day for Wednesday let’s suppose. For this first Week, the image looks like: Because we … Continue reading

Posted in CalculatedColumn, Sharepoint Online | Comments Off on Calculating Working Hours – days in first week

Calculating Working Hours

  …this post was published on 2016 March 31. between 2 dates in Sharepoint using only Calculated Columns. Well this is a challenge. Not a really new one ( because it was another topic but not for hours, only for working days … Continue reading

Posted in CalculatedColumn, Sharepoint Online | Comments Off on Calculating Working Hours

Validation: Force only Sundays

…this post was published on 2016 February 02. How can force Sharepoint to permit only past sundays in a date column? The request was posted at this address​. To permit only sundays, it’s quite easy. You configure a validation condition at column … Continue reading

Posted in CalculatedColumn, Uncategorized, Validation | Comments Off on Validation: Force only Sundays

Get the MAX value from columns

…this post was published on 2015 December 3. The issue is: how to calculate the  MAX for 4 adte columns and also compare with another << Today>> value column The complete post is this one For this, let me create a new … Continue reading

Posted in CalculatedColumn, Sharepoint, Sharepoint 2013 | Comments Off on Get the MAX value from columns

Calculate Q/YY from a date column

…this post was published on 2015 December 1. Starting from this post, let’s start I create a new list, with only 2 new fields First one with the name [Date] as Date type column and a new calculated column, name [Q/YY] Before I … Continue reading

Posted in CalculatedColumn | Comments Off on Calculate Q/YY from a date column

Calculated Columns

Case 1 Used Columns: COL_TXT1, COL_NO1, COL_NO2 Calculated Column Formula: =IF(COL_TXT1=””;IF((COL_NO1+19)<=(COL_NO2+7);COL_NO2+7;COL_NO1+19);””) Explanation: If text column is blank show nothing, else based on number columns show a calculated value Example:  COL_NO1+19 =<COL_NO2+7 then COL_NO2+7 else COL_NO1+19 LINK SharePoint 2010: N/A SharePoint … Continue reading

Posted in CalculatedColumn, Sharepoint 2010, Sharepoint 2013, Sharepoint Online | Comments Off on Calculated Columns

Sharepoint 2013 Evaluating Choice Column value in calculated columns

…this post was published on 2015 July 14. Let’s consider the following scenario , started from this post on MS Forum platform << you need a calendar list with a column,  a numeric one : [ TrailerNumber], the second one as … Continue reading

Posted in CalculatedColumn, Sharepoint 2013 | Comments Off on Sharepoint 2013 Evaluating Choice Column value in calculated columns

ID field in calculated column

…this post was published on 2015 June 3. SharePoint’s ID field is the last filled when you create an item , add a document in a library. When you push Save button creating a NewItem, first are filled standard fields, next … Continue reading

Posted in CalculatedColumn, Sharepoint 2013 | Comments Off on ID field in calculated column

Filtering list’s items for the next month

…this post was published on 2014 September 17. Starting from this request, I create first a new list with 2 more columns: -first one: Birthday, a date type column; -second one: Month, a calculated column; defined as bellow As you can … Continue reading

Posted in CalculatedColumn, Sharepoint | Comments Off on Filtering list’s items for the next month

Calculated interval

…this post was published on 2014 September 8. ​Starting from this post, let’s suppose that we have 2 numeric columns, Start and Stop  and  other 2 columns Min_value and Max_value. The request is to calculate calculate if our interval between Start … Continue reading

Posted in CalculatedColumn, Sharepoint | Comments Off on Calculated interval