Search

Recent Posts
Recent Comments
Archives
Categories
… on Youtube
… on Twitter
 Wallpaper of the Week Red freshness https://t.co/bfqWD7Gmr7 #strawberry #canon #fresh #wallpaper https://t.co/UH6vu5Lgrfyesterday
 RT @microsoftgulf: Join us at the SharePoint Virtual Summit, to learn how to leverage Microsoft technologies in #DigitalTransformation http…6 days ago
 Wallpaper of the Week: 19/2017 Raindrops https://t.co/HGKa0GvUTA #raindrops #strawberry #canon #wallpaper https://t.co/be06qiO8Fu9 days ago
 RT @NeowinFeed: Microsoft patches Windows 8, XP, and Server 2003 to combat 'WannaCry' ransomware attack https://t.co/5xv69FGbnA https://t.c…9 days ago
Category Archives: CalculatedColumn
Sum of time values for two DateTime columns
Starting from this post let’s suppose that your two DateTime Columns are COL_DAT1 COL_DAT2 and the request is to sum the time values. The final value ( as a text ) will be in this format hh:mm. For this you will need … Continue reading
Posted in CalculatedColumn, Sharepoint Online
Comments Off on Sum of time values for two DateTime columns
Validation item in Sharepoint
…this post was published on 2017 March 03. How we can force users to fill a secondary line text if another column ( yes/no ) is checked as Yes Suppose that , the Yes/No column with the name yesno, and as single line text column … Continue reading
Posted in CalculatedColumn, Sharepoint, Sharepoint Online, Validation
Comments Off on Validation item in 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? Event it is empty, that doesn’t mean that no value is there. The value stored inside is:30.12.1899 In … Continue reading
Posted in CalculatedColumn, Sharepoint
Comments Off on Empty DateTime Field in Calculated Column
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