Tag: process

Troubles with O365 Permissions and OneNote

Jon was having issues with not being able to edit pages in our team’s OneNote notebook. He reminded me that we dealt with something similar when he first started working here and that I was able to fix that issue pretty quickly, but something must have changed since then because those pages are a subset of the larger notebook that we’re now having issues with.

We believe we have a working solution: SharePoint > Site Contents > Site Assets > Options > Share > Who would you like this link to work for? Specific People > Apply > [add email address] > Send.

This appeared to work for his laptop and iPad when accessing OneNote using the web interface, not the native apps. Hopefully this is the solution we’re looking for. We’ll know in our upcoming Weekly Office Meeting.

I tried a slightly different approach that worked temporarily, but didn’t lead to a permanent fix: SharePoint > Site Contents > Site Assets > Options > Manage access > adjust permissions to “Can edit.”

Smartsheet: Index, Match, @Row

I am trying to build out a new process using Smartsheet and was just recommended by Laura Adams to consider using Index & Match instead of VLookup because it requires less resources, makes it easier to reproduce, and is more secure.

index, match vs. vlookup

How to build an Index-Match formula

Example

Let’s say you had a simple sheet that listed the faculty contact for any given course. In another sheet, you would like to pull that information in and you can as long as you have a cell with the same course information. This allows you to have a number of smaller source sheets that contain useful information that needs to be referenced in a number of other sheets.

You would set up your index-match function by:

  1. identifying (referencing) the column in the source sheet with the names of the faculty
  2. identifying the column in the destination sheet that contains the course information for each of the faculty
  3. identifying the column in the source sheet that contains the course information you are matching to

I’ve created some public sheets which anyone should be able to view to see this very simple example of index-match at work:

It is easy to get confused what gets referenced where in the formula.

Laura’s example above includes an IFERROR function that helps to turn “#NO MATCH” errors into either blanks or some other more useful, human-friendly message.

Some additional resources:

Moving Canvas Video Assets to Box.psu.edu

I’ve finally begun a project with our multimedia specialists to move our video content in Canvas to Box.psu.edu. We have a few courses that include downloadable video files as stored assets within Canvas. We were still working out our workflow at the time, and we decided that we need to do something better that our default.

Some of our students are commuting and prefer to have videos on their devices so that they can watch the content while on-the-go. By using Box.psu.edu, we have unlimited amount of storage to put our video assets for students. Box provides revisioning, access from various platforms, syncing to the cloud, collaboration, and more. We’re currently using College resources to store live and working documents and while that’s been great in the past, we’re enjoying new functionality with Box.

I’ve created a screencast of a discussion about what an initial workflow will look like. Howard is going to start and document changes as he goes.

[Internal: see Footprints Ticket #806]

ANGEL: Certificate-Generating Tool Instructions

I met with a group of IDs and IPSs from Outreach to present on some work that I did while working on a solution for the PSU School of Nursing.

I have documented my overview, procedures, and implementation notes in an Evernote: “ANGEL: Certificate-Generating Tool Instructions“.

This project covers the design, development and implementation of a solution that was developed to automatically generate certificates-of-completion for participants taking online continuing education credits. Nurses in PA need to maintain professional development credits in an ongoing basis. PSU Outreach worked with the School of Nursing to develop self-paced online learning that would satisfy this need.