User Profile
Ashley
Iron Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Archive a SharePoint Landing Page for Past Conference
I have taken over ownership of an annual event and need to "archive" the current SharePoint landing page in a SharePoint Communication Site. We want to start fresh with this year's site but still provide easy access to the 2023 site for reference. How can I set up user-friendly navigation to allow people to look back at the 2023 site?Did Not Receive an Email Notification that a Document Had Been Shared
I shared a OneDrive for Business document with a user in my organization via the "people you choose" sharing link. I then asked that user to share the document with someone else. What I was expecting to happen was: they would be able to share the document, and I would an email notification that the document has been shared. What I did not want to happen was: they are unable to share the document, and I do not get an email notification that it has been shared. The user was able to share the document (expected behavior), but I did not receive an email notification that it had been shared (undesired behavior). Thoughts?Change the Layout to Show Each Presenter Name on Different Line
I would like to change the layout in the Current worksheet of the attached file to look like the sample layout in the New worksheet. Technically, I want to tell Excel to: Go to the Current worksheet Replace the word Submitter with Presenter in F1:J1 Start in row 2 and tell me if there is text in the original N2:R2 If yes, insert a duplicate row below the current row and replace the values in new F2:J2 with the values in new N2:R2 Next, tell me if there is text in the original S2:W2. If yes, insert a duplicate row below the current row and replace the values in newRow1 F2:J2 with the values in newRow1 S2:W2. Next, tell me if there is text in the original X2:AB2. If yes, insert a duplicate row below the current row and replace the values in newRow2 F2:J2 with the values in newRow2 X2:AB2. Next, tell me if there is text in the original AC2:AG2. If yes, insert a duplicate row below the current row and replace the values in newRow3 F2:J2 with the values in newRow3 AC2:AG2. Finally, go to the next original line and repeat to the end. How do I do that without doing it manually? Ashley Adams University of North Carolina Wilmington Please excuse any typos.VIDEO REQUEST: The "Edit a Sent Message" Experience
Today, in the systems coordination committee meeting at my university, we weighed the pros & cons of enabling "Edit a Sent Message" in Teams. The group activity went well and I was tasked with locating a video on the experience. Could someone share a video showing: how to edit a sent message in Teams, does it show message history, does it bring the edited message down into the most recent activity, who can edit a sent message, and/or where to turn on "edit a sent message" in the Microsoft 365 Admin Center. Thank you, Ashley Adams, IT Trainer University of North Carolina WilmingtonHow do I include a range in my IFS function?
I would like Excel to return "Great" as the overall rating if: the total score is less than or equal to 166 the total score is greater than or equal to 167 and less than or equal to 233 the total score is greater than or equal to 234 and less than or equal to 300 My attempt is attached, but I was expecting the overall rating to return "great" and it returned "good." Any advice?Remove leading spaces w/o removing all spaces
How do I remove the leading spaces / phantom spaces in this data without removing all spaces? I already tried using: Find & Replace Text to Columns > Fixed Width The second option works for this small data set, but it would not work well with a large one. All ideas are welcome!Change the layout of my data
I would like to change the layout of my data from the course data for each student ID showing up in rows to course data being listed at the top in column headers and student IDs below. Sample file attached. How do I do that? Change From Student ID Course 1 Course 2 Course 3 2 2021 FA2 MBA 504 2021 FA2 MBA 562 2022 SP1 MBA 514 3 2021 FA1 BAN 500 2021 FA2 MIS 592 2022 SP1 BAN 501 4 2021 SU1 MBA 516 2021 SU2 MBA 504 2021 FA1 MBA 508 Change To 2021 FA1 MBA 508 2022 SP2 MIS 503 2023 SP1 MBA 532 2024 SP1 MBA 516 6 51 66 151 10 54 67 36 13 58 74 Any ideas are greatly appreciated, Ashley Adams
