How to hide the unassigned items bucket from the board view in Microsoft Lists

Microsoft Lists is a great tool for creating and managing lists of data, tasks, events, and more. One of the features of Microsoft Lists is the ability to create a board view based on choice columns. This allows you to group and visualize your list items by different categories, such as status, priority, or owner.

However, there is a default bucket that is always visible in the board view, even if the column you selected to be used as the buckets is defined as mandatory. This bucket is called “Unassigned items” and it shows the items that have no value for the choice column. This can be annoying and confusing, especially if you have a large list with many items and buckets.

(more…)

By João Ferreira Feb 23, 2024 Views 0 Comments

New Calendar Views for Microsoft Lists

In May 2023, Microsoft announced some exciting new features for Microsoft Lists, such as custom forms, new and faster interface, rating columns by default among others. Some of these features are expected to start rolling out in February 2024, but some of them have already started to land quietly in the Lists app.

(more…)

By João Ferreira Jan 26, 2024 Views 2 Comments

How to group and sort a Microsoft Lists view by month

Microsoft Lists is a powerful tool that allows you to create and manage data in various ways. You can use lists to track issues, tasks, contacts, inventory, and more. One of the features that makes lists so versatile is the ability to create different views of your data. Views let you filter, sort, group, and format your list items according to your needs and preferences.

One common scenario that many users face is how to group their list items by month. For example, you might want to see how many tasks were completed, how many issues were resolved, or how much revenue was generated in each month. Grouping by month can help you identify trends, patterns, and outliers in your data.

In this blog post, I will guide you step by step through the process of creating a list view that is grouped and sorted by month in chronological order. You will learn how to create calculated columns, use formulas, and adjust sorting options to achieve the desired result.

(more…)

By João Ferreira Jan 5, 2024 Formatting, Views 0 Comments

How to create a video playlist for Stream Videos

A video playlist is a collection of videos, typically related in some way, that play in a specific order. Playlists are commonly found on video sharing platforms like YouTube and allow users to watch a series of videos without having to manually search for and select each video.

Recently SharePoint lists and Microsoft Lists got a new playlist template that can be used to create playlists of Videos hosted in SharePoint that are reproduced in the new version of Microsoft Stream.

(more…)

By João Ferreira Feb 9, 2023 Views 2 Comments

How to create a Year view in SharePoint and Microsoft Lists

With the year starting it is time to recreate or update the systems used last year to store and manage information, and that’s exactly what I’m doing in these first days of the year.

Last year I started to use a list to manage payments and I would like to continue to use the same one this year, at the same time I would like to create year views to access the data from separate years when needed.

(more…)

By João Ferreira Jan 4, 2023 Microsoft Lists, Views 0 Comments