Category Archives: Sharepoint

Empty DateTime Field in Calculated Column

  …this post was published on 2016 May 17. You need to check and maybe to use later if a Datetime field is empty or not? Even if it is empty, that doesn’t mean that no value is there. The value stored inside is:30.12.1899 … Continue reading

Posted in CalculatedColumn, Sharepoint | Comments Off on Empty DateTime Field in Calculated Column

Dynamic Filtered Views

  …this post was published on 2016 March 31. You need to show items in a list , filtered by specific value? And of course you don’t want to create a specific view for that value? You can use a generic URL … Continue reading

Posted in filter, Sharepoint, URL | Comments Off on Dynamic Filtered Views

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

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

MVP for the third time

…this post was published on 2015 September 24. For the third year I have been awarded as MVP for Sharepoint Server.  Glad and honored. I would like to thank for this award and for all offered oportunities. Happy to be a member of … Continue reading

Posted in MVP, Sharepoint | Comments Off on MVP for the third time

Managing Content Types for a list with Powershell

…this post was published on 2015 September 24. First i created a new content type – this time using GUI. The name for this new content type ( Type Item ) it is: Custom_Content1 It is a minimal item ( with default … Continue reading

Posted in csv, Powershell, Sharepoint 2013 | Comments Off on Managing Content Types for a list with Powershell

Working hard for Collab365

…this post was published on 2015 August 30.

Posted in Collab365, Sharepoint | Comments Off on Working hard for Collab365

Getting files from a specific folder in a doc lib powershell

…this post was published on 2015 August 2. $yourweb=”http://shp2013″ $yourlist=”Documents” $yourfolder=”folder1″ $results = @() $web = Get-SPWeb $yourweb $my_list = $web.Lists | Where-Object { $_.Title -eq $yourlist} foreach ( $item in $my_list.Items){ if ($item.File.ParentFolder.name -eq $yourfolder){ $results = $results+$item.Name } } … Continue reading

Posted in Files, Powershell, Sharepoint | Comments Off on Getting files from a specific folder in a doc lib powershell

Sharepoint 2013 – Site Experience Version with Powershell

…this post was published on 2015 July 26. Starting from this old post, let’s  try to use Powershell to work with Site Experience and set it a default mandatory value at webapplication level. The WebApplication property is CompatibilityRange To change the … Continue reading

Posted in error, Powershell, Sharepoint 2013 | Comments Off on Sharepoint 2013 – Site Experience Version with Powershell

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