Extract date components using the TEXT() function in SharePoint calculated columns

In your SharePoint form submissions and list items, sometimes you'd like date fields to be displayed a different way for workflows, notifications, views, grouping, additional metadata, etc. See video at bottom of post for an example use case and tutorial.…

5 ways you can use SharePoint list and library view settings to improve the user experience

SharePoint has many out-of-the-box (OOTB) ways to improve the way data is displayed in lists and libraries. Many of these can alleviate headache your users experience when adapting to a new way of working with their abundance of ever-growing information.…

10 reasons putting team/department documents in SharePoint is better than shared drives: Part 2

This post is a continuation of 10 reasons putting team/department documents in SharePoint is better than shared drives. See part one for information about: Version history Approvals/Administration Check-in/Check-out Co-editing Archiving & retention And below for information about: Sharing and security…

10 reasons putting team/department documents in SharePoint is better than shared drives: Part 1

You know that one file, right? The one named "Agenda.docx" in the folder called "November" in the "2008" folder in another folder called "DO NOT Delete" in the "Archive" folder of the "Retired Committees" folder? Me either. And chances are…

How to add rows for dates between start and end dates in Power BI date range data

In Power BI there are several custom visuals available, such as Elastacloud's Calendar Visual, that show the density of events over time. However, if your data includes date ranges (start date with a different end date, such as task/project lists), visuals…

Set multiple choices as default values for checkbox fields in SharePoint forms

I recently worked on a project for a client that needed 2/3 checkbox options checked by default on a new form. While not as straight-forward as other field types, it's still certainly possible. Go to List --> List Settings (server/on-prem) or…

Replace SharePoint attachment paperclip icons with actual hyperlinked attachment names in list views

You can attach documents to SharePoint list items. However if you add the "Attachments" column to your list views, you get a column that only shows a paperclip icon (see below) if there are any attachments. Clicking that paperclip also won't open…

Solution: “We’re sorry. We can’t open {file} because we found a problem with its contents.”

When using SharePoint Designer workflows to automatically create documents from a template you might run into an error message: "We're sorry. We can't open {file} because we found a problem with its contents." Or if you're just opening it within…