2026
Every post published in 2026, newest first. Pick a month to narrow it down.
- Posts
- 1,054
- Topics
- 114
- Reading time
- 128 h
- Active months
- 6
Posts 301–330 of 1,054 · November 7, 2026
Page 11 of 36
November 2026
802 postsSaturday, November 7, 2026
30 of 94 posts
How to Stop Inheriting Permissions on a SharePoint List
Give a SharePoint list its own permissions with Stop Inheriting Permissions: where the button is, the confirmation it shows, and the copy of the site's groups it leaves on the list.
6 min readHow to Create a Custom Permission Level in SharePoint
Copy SharePoint's Contribute permission level, clear Delete Items and Delete Versions, and save it as Contribute Without Delete: people can add and edit items but not delete them.
8 min readHow to Give a Group Read-Only Access to a SharePoint Site
Let a whole security group view a SharePoint site without changing anything: Share site with Read adds the group to the site's Visitors group. No email, and how to check it worked.
7 min readFixed: SharePoint Saves a Typed Date in the Wrong Month
On a UK SharePoint site, 07/11/2026 typed into a date and time field was saved as 11 July instead of 7 November, for one user only. What I checked, what I couldn't explain, and the fix: pick the date from the calendar.
7 min readBuild an Overtime Timesheet App in Power Apps — Part 2: Create the SharePoint Site and Lists
Create the SharePoint site behind the Overtime Timesheet app: UK dates and London time, a Departments list with approvers, an OvertimeEntries list with a validation rule and indexes, and a library for payroll's workbooks.
22 min readHow to Add an Item to a SharePoint List
Add an item to a SharePoint list with + New: fill in the New item form, pick people in a Person field, save, and see the item in the list.
5 min readHow to Rename a SharePoint Library Without Changing Its URL
Give a SharePoint document library a friendly name with spaces while its web address stays short and space-free: create it without spaces, then rename it in Library settings.
4 min readHow to Create a Document Library in SharePoint Online
Create a document library on a SharePoint site with + New → Document library: a blank library or a template, a name that becomes its web address, a description, and whether it shows in the site's navigation.
5 min readHow to Add List Validation in SharePoint to Compare Two Columns
Use a SharePoint list validation formula to check columns against each other when an item is saved, such as a finish time after the start, with your own message when the check fails.
7 min readHow to Hide the Title Column in a SharePoint List
Hide the built-in Title column of a SharePoint list from both the list view and the item form, check first that it isn't required, and see why hiding it beats renaming it.
6 min readHow to Enforce Unique Values in a SharePoint List Column
Stop duplicates in a SharePoint list with Enforce unique values: switch it on, see the index SharePoint adds for it, the This value already exists in the list message, and which column types support it.
6 min readHow to Add a Description to a SharePoint List Column
Add a description to a SharePoint list column so the item form explains each field right under it: where to type it, where it appears, and how to write descriptions people actually read.
4 min readHow to Set a Default Value for a SharePoint List Column
Give a SharePoint list column a default value so new items start filled in: Yes for a Yes/No column, 0 for a number, a starting choice such as Pending, or today's date.
5 min readHow to Make a Column Required in a SharePoint List
Make a SharePoint list column required with Require that this column contains information, see how the form marks it with an asterisk and blocks blank values, and what required doesn't cover.
5 min readHow to Add a Multiple Lines of Text Column to a SharePoint List
Add a Multiple lines of text column to a SharePoint list for comments and reasons: plain text or enhanced rich text, Append changes to existing text, and what this column type can't do.
6 min readHow to Add a Person Column to a SharePoint List
Add a Person column to a SharePoint list to store people from your organization instead of typed names: allow multiple people, people only or groups too, and what changes when it holds several people.
6 min readHow to Add a Date Column to a SharePoint List (Date Only or Date and Time)
Add a Date and time column to a SharePoint list and choose between date only and date and time with the Include Time switch, plus friendly format and the default value options.
6 min readHow to Set a Minimum and Maximum Value for a SharePoint Number Column
Stop impossible numbers in a SharePoint list: set a Number column's minimum and maximum allowed values, and see the message SharePoint shows when someone saves a value outside the range.
5 min readHow to Add a Number Column to a SharePoint List
Add a Number column to a SharePoint list and set it up properly: the number symbol, decimal places, a default value, the thousands separator, and the minimum, maximum and required options.
6 min readHow to Show Times in 24-Hour Format in SharePoint
Make a SharePoint site show 22:00 instead of 10:00 PM: set Time format to 24 Hour in the site's Regional settings. Why the locale can change it for you, and why the date picker's time box may still say PM.
5 min readHow to Change the Date Format of a SharePoint Site
Make a SharePoint site show dates as dd/mm/yyyy by changing its Locale in Regional settings. English (United Kingdom) also starts weeks on Monday and switches to the 24-hour clock.
7 min readHow to Change the Time Zone of a SharePoint Site
A new SharePoint site takes the SharePoint admin center's time zone, which is Pacific Time unless an admin changed it. Set the site's own time zone in Regional settings so its lists and forms use yours.
7 min readFixed: SharePoint People Picker Shows a User's Old Job Title
A SharePoint Person field suggested Olivia Bennett as Head of Sales, hours after her job title changed in Microsoft Entra. SharePoint keeps its own copy of profiles and updates it on a schedule; here's how I confirmed it.
5 min readBuild an Overtime Timesheet App in Power Apps — Part 1: Plan the App and Set Up the Demo Organization
Start a series that replaces an Excel overtime timesheet with a Power Apps app on SharePoint: what it does, how it's designed, what it costs, the demo organization, and the old Excel timesheet it replaces.
24 min readHow to Calculate Hours Worked Across a Daylight Saving Time Change in Excel
Excel ignores clock changes, so a 22:00 to 06:00 night shift is 8 hours even when the clocks go back and it lasts 9. Work out the UK change times with DATE, WEEKDAY and TIME, and correct the hours.
9 min readHow to Check Two Conditions at Once in Excel with AND
Test whether two things are both true in Excel with =AND(test1, test2), which returns TRUE or FALSE. Real example: does a shift start before a moment and end after it? And how TRUE counts as 1 in a sum.
4 min readHow to Add Hours to a Date in Excel with TIME
Add a time of day to a date in Excel with =date+TIME(hours, minutes, seconds), such as 29/03/2026 + TIME(1,0,0) for 01:00, and give the result a format that shows the time.
4 min readHow to Find the Last Sunday of a Month in Excel
Find the last Sunday of any month in Excel with DATE and WEEKDAY: take the first of the next month and subtract the weekday number of the day before it. Worked out for March and October 2026.
4 min readHow to Get the Day of the Week as a Number in Excel with WEEKDAY
Turn a date into its day of the week with =WEEKDAY(date): 1 for Sunday to 7 for Saturday. Real results for 31 March and 31 October 2026, and how a date minus 1 gives the day before.
4 min readHow to Build a Date from a Year, Month and Day in Excel with DATE
Make a real Excel date from separate numbers with =DATE(year, month, day): =DATE(B1,4,1) is 1 April of the year in B1. Useful when the year changes and the dates should follow.
4 min read