SharePoint
SharePoint is where a huge amount of team work actually lives, and I want to help you get the most out of it. Here you find my hands-on articles on lists, document libraries, permissions, and the automation that ties everything together. If you manage files, I walk through how to add properties to SharePoint files, check whether a document library already exists, and create nested folders while copying templates using Power Automate. Love a tidy interface? I cover advanced column formatting, calculated fields, and how to color-code your columns so a list tells its story at a glance. There are fixes for the little things that trip people up, like images not showing in Gallery View, plus bigger ideas such as publishing news straight from an RSS feed and setting up automatic document management. You will also find best practices and reference pieces like lookup and reverse lookup tables.
Power Apps: How to create an app with SharePoint in 2 minutes
SharePoint: ISNA Function
Returns true when a value is the #N/A error.
SharePoint: Blog and Video to better share information
SharePoint: ISNUMBER Function
Returns true when a value is a number type.
SharePoint: Your team’s “face” in the organization
SharePoint: Day Function
Returns the day-of-month number from a date.
SharePoint: How to create site columns?
SharePoint: ISBLANK Function
Returns true when a column is empty.
SharePoint: Color-code your columns
Microsoft Forms: Format Submitted Data
SharePoint: Choose Function
Returns one value from a set based on an index number. Up to 29 items.