Category Archives: Sharepoint Online

Powershell and Sharepoint – Ep. 2 – Updating a picture library on O365 from Flickr site

…this post was published on 2016 July 24. Hi ​bellow is the script ready to be used to update a picture library in Sharepoint Online with information from Flicrk.com $results = @() Import-Module MSOnline $global:cred = Get-Credential Connect-MsolService -Credential $global:cred $url = … Continue reading

Posted in Office 365, Powershell, Sharepoint Online, YouTube | Comments Off on Powershell and Sharepoint – Ep. 2 – Updating a picture library on O365 from Flickr site

Sites icon replaced by Sharepoint – Finally

  …this post was published on 2016 June 22. After a long long and epic waiting 🙂  MS changed <<Sites>> icon with Sharepoint name in Office 365 tenant panel for CEE DataCenter. ​ Should I say that I’m waiting for planner link … Continue reading

Posted in Office 365, Sharepoint Online | Comments Off on Sites icon replaced by Sharepoint – Finally

Calculated Columns for Yes/No columns in Sharepoint

  …this post was published on 2016 May 3. Starting from this post, let’s suppose  that we have following colunms: Col_A, COL_B, COL_C, COL_D and COL_E. All columns are Yes/No Columns. The default value for them it isn’t so important ( in calculation columns, … Continue reading

Posted in CalculatedColumn, Sharepoint Online | Comments Off on Calculated Columns for Yes/No columns in Sharepoint

Calculating Working Hours – same day with lunch break

…this post was published on 2016 March 31. What if we need to calculate working hours in a day, minus lunch time? This request it’s also present on MS Forum. Let’s suppose that our list contain the following columns, DateTime type columns: … Continue reading

Posted in CalculatedColumn, Sharepoint Online | Comments Off on Calculating Working Hours – same day with lunch break

Calculating Working Hours – total working hours

 …this post was published on 2016 March 31. Finally. last moment! TOTAL We need to add some columns. And because our last 2 columns are in minutes, we will transform first 3 columns from full days in minutes and will add the … Continue reading

Posted in CalculatedColumn, Sharepoint Online | Comments Off on Calculating Working Hours – total working hours

Calculating Working Hours – hours in last day

…this post was published on 2016 March 31. The final step is to calculate working hours in the last day. The procedure is similar with working hours in first day​​ We need first, 2 new columns, calculated columns, which will calculate for … Continue reading

Posted in CalculatedColumn, Sharepoint Online, Uncategorized | Comments Off on Calculating Working Hours – hours in last day

Calculating Working Hours – hours in first day

…this post was published on 2016 March 31. The last 2 steps are those for calculating hours in first  and last day. Let’s begin with the first day. As I said in main post, we assume that the working day begins at 8.30am … Continue reading

Posted in CalculatedColumn, Sharepoint Online, Uncategorized | Comments Off on Calculating Working Hours – hours in first day

Calculating Working Hours – days in full weeks

…this post was published on 2016 March 31. Well, this is the hardest step in this scenario because we need to analyze the interval between StartDate and EndDate, to get the number of full weeks. The structure could looks like below: To … Continue reading

Posted in CalculatedColumn, Sharepoint Online, Uncategorized | Comments Off on Calculating Working Hours – days in full weeks

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