Creating a persistent Microsoft Forms response spreadsheet

If you use Microsoft Forms, you know that in order to see the responses you need to export them to Excel. However, having to export them *every single time* you want to see the responses can be a pain point. Did you know you can pre-create the Microsoft Forms response spreadsheet in OneDrive, and then you simply have to open it to see the most up-to-date responses to your Form? Here’s how that works…

Creating Tasks from a Microsoft Teams chat entry

The nice thing about having a wife who is a user training and adoption specialist is that she lets me know about cool tips she finds… and this one is pretty cool! You can create a task from a Microsoft Teams chat entry, which is perfect when you have something you need to follow up on. Here’s how that works…

One Minute Office Magic is 500 posts old!

One Minute Office magic reached the 500 post milestone today! I started writing SharePoint posts back in 2015, and then slowly widened the focus to Office 365 (now Microsoft 365). I can’t believe I’ve produced and shared that much content over the years…

Here’s to another seven years and 500 posts. Thanks for being part of the journey!

Splitting up the Collect Responses and Collaboration options in Microsoft Forms

When Microsoft Forms first came out, there was a single button that had the options for both collecting responses from people and for letting others collaborate on building your form. Unfortunately, this often led to people getting links to collaborate when in reality they should have only been able to respond. Now, Microsoft has split those two options out to clarify the options. Here’s what that looks like…