office 365
20880 TopicsDynamic Distribution Group with no Disabled Accounts
Hi I'm trying to build a few Dynamic Distribution Lists in Exchange Online and want to only include Active Users (i.e., users that are marked "Active" in Azure AD). I've tried using the UserAccountControl attribute (-eq 514 or -ne 514 - both are returning the same results, which is strange), but it still includes user accounts that are disabled. This is how my recipient filter looks like: RecipientType -eq 'UserMailbox' -and UserAccountControl -ne 514 What's the best way to achieve this in Exchange Online? Thanks Taranjeet Singh1.9KViews0likes4CommentsEnhancements to Planner in Microsoft Teams channels
By adding Planner as a Teams tab, you can now seamlessly create and add both basic and premium plans directly to your standard Teams channels. This includes the ability to start a plan as a tab from any of our out-of-the-box templates. This unified experience means everything you need is now in one place, making it simpler to collaborate on shared projects right within your conversations. Try it out To get started, follow these steps: Select any standard Teams channel. Select the Open Apps icon at the top right of the channel and search for Planner. Select Pin a tab for Planner. Select Save. You can now add an existing plan to the channel or create a new plan. Note: When you create a new plan, you have the option of starting from scratch or trying one of our templates. These templates range from event planning to building a CRM pipeline. A video demonstrating how to pin a tab for Planner and create a shared space for using the app in a Teams channel. What’s new to Planner in Teams channels One of the most significant advantages of adding Planner as a tab to a Teams channel is the ability to track your work, visualize progress towards goals, and monitor workloads—all within the context where your team works. Our most recent updates extend this benefit further by integrating both basic and premium plans directly into your Teams channels. By consolidating these into a single interface, you can now create and manage your plans without needing to switch between different apps or tabs. As your project requirements grow, you can also easily upgrade to a premium plan from a basic plan right within the Teams tab. This transition between plan types ensures that you can get access to the features you need as seamlessly as possible. This includes capabilities such as: Task dependencies: View and manage the relationship between interconnected tasks. Task history: Review all progress and changes made to tasks. Custom fields: Keep track of important information specific to your plans and workflows. Subtasks: Break down complex deliverables into smaller, more actionable tasks. People view: Visualize and manage team members and their workloads, assign tasks, track progress, and collaborate efficiently, ensuring everyone stays aligned and productive. Goals view: Set, track, and link project goals to tasks, ensuring alignment and visibility of progress towards key objectives. Copilot: Leverage AI to assist users in planning, managing tasks, and generating project insights, enhancing productivity and project visibility. Baselines: Capture and compare the state of a project at specific moments, helping to track progress and identify variances from the original plan. Portfolios: These plans can now be added to portfolios. Check out the full list of advanced capabilities with premium plans in Planner. If you don’t have a premium license, you can still try the feature by acquiring a free 30-day trial. Your team can continue to edit the same fields as before on the premium plan with their Microsoft 365 subscription. Share your feedback We’d love to get your input on this new experience! We're committed to continuously improving your experience with Planner, and your perspective is one of the channels that enables us to shape future investments. There are several ways to share your feedback with us—either via the Planner Feedback Portal or directly in the Planner app in Teams by selecting More (the questions mark) in the upper right corner, then Feedback. Resources Check out the Planner adoption page. Sign up to receive future communication about Planner. Check out the Microsoft 365 roadmap for feature descriptions and estimated release dates. Watch Planner demos for inspiration on how to get the most out of Planner. Watch the recording from September's What’s New and What’s Coming Next + AMA about the new Planner. Visit the Planner help page to learn more about the capabilities in Planner.1.3KViews1like2CommentsMS Word Spanish word Bug
Microsoft Office 2013 all the way to 2021 LTSC has a bug in the spanish language grammar and orthographic checker. The grammar and orthographic checker does not detect and mark the following words: doscientes trescientes cuatrocientes quinientes seiscientes Setecientes Ochocientes Novecientes Correct words would be with "a" or "o" as the last vocals: doscientos trescientos cuatrocientos quinientos seiscientos Setecientos Ochocientos Novecientos All of the former are the spanish names for numbers representing hundreds.24Views0likes1CommentMoving info to different Tabs
I am looking to try to have a MASTER LIST with 7 or 8 columns. I would like to have one column have the assigned person's name/number. I also want to have separate tabs (one for each person/number). Is possible to create a formula to automatically transfer all of the data from the row for each person to their corresponding tab?Solved67Views0likes4Comments=_xlfn._xlws.SORT added to some PCs but not others
Hello, So we have an efficiency tracker spreadsheet and it contains a hidden sheet with a set of formulas that are contained here. For certain Windows 10 PCs, they are able to view this spreadsheet properly with the formulas. However, we still have Windows 7 PCs that cannot view the spreadsheet properly and the file prefix: "=_xlfn._xlws" is added to the formulas while on the PCs it is working on this field is not present. I do have a Windows 10 PC with a different Office 365 subscription than my colleagues and the spreadsheet shows these same problematic fields ("=_xlfn._xlws.SORT"). Could you help me out? Thank you, Chris20KViews1like4CommentsLambda for Getting Sums Based on Dynamic Filters
A while back, someone helped me by drafting a Lambda formula that counted the number of rows in a dynamic table based on multiple dynamic filter values. I now have a need to modify it so it calculates the sums of a column in a table based on the same premise. This is the lambda formula for if it were to be applied to the same spreadsheet: =LAMBDA(tblall,BeginDate,EndDate,Dept,PRAM,LET(tbl,DROP(tblall,1),hdrs,TAKE(tblall,1),nofltr,SEQUENCE(ROWS(tbl)),result,FILTER(nofltr,(INDEX(tbl,,MATCH("Date",hdrs,0))>=Begin)*(INDEX(tbl,,MATCH("Date",hdrs,0))<=EndDate)*(IF(Dept="",nofltr,INDEX(tbl,,MATCH("Staff & Agencies Involved",hdrs,0))=Dept))*(IF(PRAM="",nofltr,INDEX(tbl,,MATCH("PRAM #",hdrs,0))=PRAM)),"None Found"),COUNT(result))) My initial thought is that the change would take place in part where it defines "nofltr" as the number of rows [.....nofltr,SEQUENCE(ROWS(tbl)),.....] and where it filters the defined "result" [...COUNT(result)....]. I can't quite figure out what needs to be modified. I've used some very convoluted IF functions in the past to do the same thing, but this has proven to be a lot neater and more scalable for large numbers of dynamic filters.77Views0likes8CommentsFormula calcular años desde 1800
Hola a todos...trabajo en un lugar donde tenemos datos de pernas que pertenecieron a este grupo desde del 1800...cuando uso la formula para calcular la edad con dos fechas (la de nacimiento, y la de muerte) me da eeror en aquellas fechas que son antes del 1900...pero las que son del signo 20 no hay problema que puedo hacer, hay alg{un modo de aumentar el rando de la fecha25Views0likes1CommentUnleash the power and fun of learning with colorful Microsoft Education Quick Guides - Summer 2024
Heather Aird’s Microsoft Education Quick Guides instantly catch the eye with their vibrant colors and engaging design. Gone are the days of dull, text-heavy manuals. These visually stunning guides are a breath of fresh air in the world of educational resources.29KViews20likes15Comments