Recent Discussions
The New Outlook Gains Colored Folder Icons
Colored folder icons doesn’t seem like a new feature that should appear in an email client that’s been around for a long time, but the new Outlook for Windows and OWA now both offer users the ability to choose different colors for folder icons. Apparently, this is an important step forward in the development of the new Outlook and might just be the killer feature to convince the curmudgeons who use Outlook classic to switch. https://office365itpros.com/2025/03/07/colored-folder-icons/
Move Sharepointonline document library to sharepointonline document library
Hello, I would like to have your feedback on moving a folder in documents from a sharepoint site to another site on the same microsoft tenant. I've used several pnp script solutions to download all the content and then send it back via Migration Manager, but it takes a long time. I've tried the move function but it's unreliable, loading runs for hours and reloading the page crashes the move. I used these two solutions to move 1 TB and it was laborious. What's the best practice for this scenario? Translated with DeepL.com (free version)
Using Target Data from another Sheet to link to Power Query Data
Hi all, I'm building a training dashboard and have used Power Query to pull through the data that comes directly from the learning system. I can show how many units each person, and then each department has completed. However, Different Departments, and then divisions within those departments have different mandatory competencies. I have these set up in another sheet in my workbook as a course database. I've set it up for Course - Tier (Mandatory or not) - Department - Division. So this table shows how many mandatory units each department must complete. My issue when trying to create relationships in that there are duplicates, as some departments have a number of the same courses. Everything else is working ok - but I need to show how many courses have been completed vs the amount of courses they need to complete each year, and in case this changes over the year (for instance if we add a new course) I want that to be dynamic instead of just saying "out of 18" for instance. Can anyone provide any guidance? I'd greatly appreciate it!Admin acces
As an organization we have an office 365 account, but we do not know who the admin/manager is. The suspicion is that it is someone who left the organization a while ago, which is why we do not have an active email address and/or password for those accounts. We cannot log in to the admin center because of this. Does anyone have a solution on how we can regain access to our office management? Telephone contact with MS has not helped so far because we do not know who the admin is and they keep asking for it or saying that we have to ask our admin.
How do I weigh ranking based on value size
Hi All Im trying to rank some numbers in excel and it works fine so far. However it is not depicting differences between values as i would like: Ranked table is on top with the following formula: =RANK(C17;$C$17:$C$23;1) / =RANK(D17;$D$17:$D$23;1) onboardings ranking 7 6 5 4 1 3 2 onboardings data 1013 248 222 139 14 51 46 Now as you can see it ranks just fine, but the difference between the highest in onboardings ranking (7) and the next highest (6) is just marginal. I would like the formula to be able to give some space in between, maybe say more like 8 or 9 and skip in between. How can i define the Rank starting at 10 and be variable in between? Thanks for the help
Excel 2021 Save As from 3rd Party Toolset
I have a 3D CAD "SolidWorks" that allows me to save out a bill of material. I has xlsx and xls as options. The issue is that Excel uses general for the cell format which changes some numbers to dates and others like -001 to -1. I have a sheet template and workbook template with the cells set as Text but since it doesn't open excel I cannot get it exported to that template. Is there a way to overcome the default from Excel? I don't see a way to even temporarily change the template as I can only find the custom sheet and workbook template I created. I asked the SolidWorks customer support VAR and SolidWorks doesn't allow me to control this or point to a specific template. Note: if I open the file with excel it changes my data and I have to manually repair it after changing the file type.Replacing Value Based on Two Conditions in Power Query
I have a list of people who have access to a certain Site Collection and Subsite. I am trying to replace a value in the Subsite column using an If-Else statement in Power Query to only replace one value if it meets the criteria. Specifically, if the Site Collection is equal to "en_ca" and the Subsite is equal to "D26 Plumbing", I want to replace the Subsite text with "D26 Plumbing and Bath". I've tried a few different equations but I either replace everything in the list with "D26 Plumbing and Bath" or I get an error. = Table.ReplaceValue(#"Filtered Rows", each [Subsite], each if [SiteCollection]="en_ca" and [Subsite]<>"D26 Plumbing" then [Subsite] else "D26 Plumbing & Bath", Replacer.ReplaceValue,{"Subsite"}) What am I missing here?Adding values generated by IF Function
Hi all trying to set up a QA spreadsheet with Yes/No answers. I used the =IF(B9="Yes"; "1";"0") To generate values in Column C I want to add up those values in column C to get a total so I used =SUM(C9:C41) but it's not generating the total. I also tried =SUM(IF(B2:B14="Yes"; 1;0)) which worked but only added up a few of the values in column C What can I do to fix this?Calculate same period in Excel
Hi everyone, I am trying to use excel to achieve the following but not sure if it something possible. For some reasons, I need it to be in excel. I have a sale sheet with customer's sales and visit. Each Customers has a start and end membership period. I wanted to calculate the sales & visit made by this customer within their current period. For example, Customer A start date is in June 24 and will end May 25. Since now is March, it will calculate the total sale or visit made between June 24 till Feb 25 and compare it with same period last year (Jun23 to May 24) and then calculate the percent change. I tried using some formula, but the calculation is wrong. For example, Customer A Visit from June24 to Feb25 should be 24 but excel answer is 22. Excel_Sales.xlsx Also is it possible to display the monthly breakdown table ie. June24 to Feb25 and June 23 to Feb24? Would appreciate any advice. Thanks so much in advance.
CountA, Unique & Filter Combined Formula Query
I'm using following formula to count unique values if criteria in 2 different columns meet. It is working fine and counts unique value when both critieria meet. However, if one column criteria doesn't meet. It returns 1 value instead of 0. =COUNTA(UNIQUE(FILTER(B:B,(A:A=H3)*(C:C=J1)))) Forexample in following picture, for programme adbfeg there is no part number on supply route 2159A, it is still returning value as 1 instead of 0 in column L. Could you please help me in finding out what's the error? Also, can you please guide how can I calculate using same formula for blank supply routes in column M. I'm not sure how to attach the file in this post as I'm new to community. If someone can please guide me, I'll attach the file as well.Office 365 API - Subscription
Hi, We have been using the Office 365 API to send events to our SIEM for a number of months. Since Monday we have received the following error: AF20023","message":"The subscription was disabled I've looked at "https://learn.microsoft.com/en-us/office/office-365-management-api/troubleshooting-the-office-365-management-activity-api#enable-unified-audit-logging-in-office-365" but even if I try and start a subscription, it will still return that it is disabled? Not entirely sure what else I can check.Vlookup help
I have done the basic Vlookup to get data from one page to another, my Excel skill is just above beginner. I created this skill matrix and I was wondering if is possible to create a page where if i enter the name and last name of the employee ( we have some siblings and relatives so both conditions have to be meet) I will display all the Employees operations where there is a number and the number so it will look like the back of a baseball card. operations Last First Role MRP Setup Troubleshooting Inspection op1 op2 Filter name1 lastname1 machineoperator1 name2 lastname2 machineoperator2 2 name3 lastname3 machineoperator3 1 name4 lastname4 machineoperator4 name5 lastname5 machineoperator5 4 name6 lastname6 machineoperator6 1 name7 lastname7 machineoperator7 3 3 name8 lastname8 machineoperator8 1 3 name9 lastname9 machineoperator9 1 name10 lastname10 machineoperator10 2 3 3 name11 lastname11 machineoperator11 1 0 0 0 3 2 name12 lastname12 machineoperator12 name13 lastname13 machineoperator13 name14 lastname14 machineoperator14 something like this: name11 lastname11 Role: machineoperator11 MRP 1 Setup 0 Troubleshooting 0 Inspection 0 Thank you in advance for any guidanceFormatting text in Controls filled by PowerAutomate
Hi. I've got a Word document template filled with SharePoint Lists data after running a PowerAutomate flow. There is some content that I need to be presented in the document as a numbered list, which I already know doesn't happen in the flow (unfortunately), so I've been trying this directly in Word, without success. I've tried two things: 1) Leaving the number placed in the template, hoping that it could follow on after a line break (what didn't happen). Before: After: 2) Removing the numbering and setting it's paragraph settings to the ruler and then inserting the numbering on the List. Before: After: And what i need is: 2. ANÁLISE 2.1. Identificou-se que (…) 2.2. Etcetcetct (…) Does anybody know how I can achieve that? I thought about posting it on the PowerAutomate forums, but since the flow itself works as it should, I concluded that I should try asking here first. Thank you in advance!Microsoft Kills Viva Goals
Microsoft’s announcement of the Viva Goals retirement came as a complete surprise to the customers using Viva Goals to implement the OKR methodology for their organization. From Microsoft’s text, it seems pretty clear that Viva Goals just didn’t succeed in winning sufficient customers to warrant ongoing development. The outcome is that Microsoft cut its losses and will retire Viva Goals. https://office365itpros.com/2024/12/09/viva-goals-retirement/
Conditional formatting - new rule based on two related column headings
Need to create a new rule that changes cell colors (column H) based on more than 2 falls (column C) in 30 days for the same person (column A). I've found the formula for just the date - but not for adding in the same name. Goal is to be alerted (visual alert) if someone fell more than 2 times in 30 days. Thanks!
Events
You’re passionate about what you do, and we’re passionate about empowering your potential. The Microsoft 365 Community Conference is your chance to keep up with AI, build game-changing skills, and ta...
In-Person
Recent Blogs
- The world of competitive spreadsheets is taking center stage at this year's South by Southwest (SXSW) with the world premiere of Spreadsheet Champions.Mar 07, 2025
- Are you ready to dive into the transformative world of Artificial Intelligence but unsure where to start? You landed at the right page. Welcome! Whether you’re just getting started or have a bit of e...Mar 06, 2025
