Category: Microsoft
Category Archives: Microsoft
Struggleing to find formula, get formula worded right.
Hello,
So we use excel for our time sheet. Each sheet (tab) is a 2 week period. Currently we have to look through the time sheets to add time up for each job. I have been trying to use the XLOOKUP formula, with little success. It would be nice to have a sheet that you punch the job number in and it brings up all time spent on a specific job number, and also indicate if it was field or drafting time.
1st week
=XLOOKUP(Sheet1!I1,Payperiod1!A9:A29,Payperiod1!D9:J29,
(lookup value(job#), sheet column Job # column, row and column for hours)
:XLOOKUP(Sheet1!A5,Payperiod1!Payperiod1!C9:C29,))
(what to lookup-drafting/field/comps, sheet drafting/field/comps column
2nd week
=XLOOKUP(Sheet1!I1,Payperiod1!A45:A67,Payperiod1!D45:J67,:XLOOKUP(Sheet1!A5,Payperiod1!C9:C29,Payperiod1!C45:J67))
This formula only gets me one day out of 3 days time is entered, =XLOOKUP(Sheet1!I1,Payperiod1!A9:A29,Payperiod1!D9:J29). Some of our jobs can be extended a month if not years when working on plats. All sheets are named Payperiod# Any advise would help thanks.
Sample of layoutHello,So we use excel for our time sheet. Each sheet (tab) is a 2 week period. Currently we have to look through the time sheets to add time up for each job. I have been trying to use the XLOOKUP formula, with little success. It would be nice to have a sheet that you punch the job number in and it brings up all time spent on a specific job number, and also indicate if it was field or drafting time.1st week=XLOOKUP(Sheet1!I1,Payperiod1!A9:A29,Payperiod1!D9:J29, (lookup value(job#), sheet column Job # column, row and column for hours):XLOOKUP(Sheet1!A5,Payperiod1!Payperiod1!C9:C29,)) (what to lookup-drafting/field/comps, sheet drafting/field/comps column2nd week=XLOOKUP(Sheet1!I1,Payperiod1!A45:A67,Payperiod1!D45:J67,:XLOOKUP(Sheet1!A5,Payperiod1!C9:C29,Payperiod1!C45:J67)) This formula only gets me one day out of 3 days time is entered, =XLOOKUP(Sheet1!I1,Payperiod1!A9:A29,Payperiod1!D9:J29). Some of our jobs can be extended a month if not years when working on plats. All sheets are named Payperiod# Any advise would help thanks. Read More
Formula Settings Issue
I am new to using formulas in Excel and am trying to figure this out for a statistics class. My instructor is requiring my standard deviation formulas to include decimals, but mine are all coming out as whole numbers. The answer is as close to being correct as it can be without the decimals, so I don’t think I am using incorrect data, but I can’t figure out how to change the settings on my formulas to include the decimals. Any help would be appreciated.
I am new to using formulas in Excel and am trying to figure this out for a statistics class. My instructor is requiring my standard deviation formulas to include decimals, but mine are all coming out as whole numbers. The answer is as close to being correct as it can be without the decimals, so I don’t think I am using incorrect data, but I can’t figure out how to change the settings on my formulas to include the decimals. Any help would be appreciated. Read More
Project Detail Page (PDP) in Project Online not saving added fields when Stop Editing clicked
Hello friends. I’ve encountered a strange situation in which I am editing a PDP in Project Online that I’ve customized in the recent past. I wish to add two Enterprise Custom Fields to a Basic Info web part.
I follow the standard steps of Edit Page > Edit Web Part > click the Modify button for Displayed Project Fields > select the two fields and click the “>” button > click Apply and confirm they show in the web part > click OK to commit > click the Stop Editing button.
The page then defaults back to the previous state. I logged into two different browsers, cleared cache, and turned on the Versioning settings for the library, using Check In and Out, then reverted back to No Versioning.
I will be checking with other admins to see if they have the same outcome tomorrow, but wondered if anyone else had experienced this situation?
Hello friends. I’ve encountered a strange situation in which I am editing a PDP in Project Online that I’ve customized in the recent past. I wish to add two Enterprise Custom Fields to a Basic Info web part. I follow the standard steps of Edit Page > Edit Web Part > click the Modify button for Displayed Project Fields > select the two fields and click the “>” button > click Apply and confirm they show in the web part > click OK to commit > click the Stop Editing button. The page then defaults back to the previous state. I logged into two different browsers, cleared cache, and turned on the Versioning settings for the library, using Check In and Out, then reverted back to No Versioning. I will be checking with other admins to see if they have the same outcome tomorrow, but wondered if anyone else had experienced this situation? Read More
New Blog | What’s new in Microsoft Entra – June 2024
Have you explored the What’s New in Microsoft Entra hub in the Microsoft Entra admin center? It’s a centralized view of our roadmap and change announcements across the Microsoft Entra identity and network access portfolio so you can stay informed with the latest updates and actionable insights to strengthen your security posture.
Here in the Microsoft Entra blog, we share feature release information and change announcements every quarter. Today’s post covers April – June 2024. It’s organized by Microsoft Entra products, so you can quickly scan what’s relevant for your deployment.
Microsoft Entra ID
Microsoft Entra ID Governance
Microsoft Entra External ID
Microsoft Entra Permissions Management
Microsoft Entra Verified ID
Read the full post here: What’s new in Microsoft Entra – June 2024
By Shobhit Sahay (ENTRA)
Have you explored the What’s New in Microsoft Entra hub in the Microsoft Entra admin center? It’s a centralized view of our roadmap and change announcements across the Microsoft Entra identity and network access portfolio so you can stay informed with the latest updates and actionable insights to strengthen your security posture.
Here in the Microsoft Entra blog, we share feature release information and change announcements every quarter. Today’s post covers April – June 2024. It’s organized by Microsoft Entra products, so you can quickly scan what’s relevant for your deployment.
Microsoft Entra ID
Microsoft Entra ID Governance
Microsoft Entra External ID
Microsoft Entra Permissions Management
Microsoft Entra Verified ID
Read the full post here: What’s new in Microsoft Entra – June 2024 Read More
OUTLOOK says external drive backup file cannot be found
I have:
Microsoft® Outlook® for Microsoft 365 MSO (Version 2406 Build 16.0.17726.20078) 64-bit
I backup OUTLOOK Inbox and local folders by using the Open & Export way:
Open & Export à Import/Export à Export to a File
Like this.
The backups go to an external drive.
I deleted a backup file on the external drive named F:OUTLOOK Backup – Inbox – 03-30-24.pst because I didn’t want to keep it around.
When I then opened OUTLOOK, it gave the error:
The file F:OUTLOOK Backup – Inbox – 03-30-24.pst cannot be found.
To get around this, I copied a backup file and renamed it to the not found file.
OUTLOOK then opened normally.
Why is OUTLOOK looking for a backup file on an external drive? How does it know it exists? Or existed?
I have:Microsoft® Outlook® for Microsoft 365 MSO (Version 2406 Build 16.0.17726.20078) 64-bitI backup OUTLOOK Inbox and local folders by using the Open & Export way:Open & Export à Import/Export à Export to a FileLike this.The backups go to an external drive.I deleted a backup file on the external drive named F:OUTLOOK Backup – Inbox – 03-30-24.pst because I didn’t want to keep it around.When I then opened OUTLOOK, it gave the error:The file F:OUTLOOK Backup – Inbox – 03-30-24.pst cannot be found.To get around this, I copied a backup file and renamed it to the not found file.OUTLOOK then opened normally.Why is OUTLOOK looking for a backup file on an external drive? How does it know it exists? Or existed? Read More
Stop internal emails from being reported to sec ops mailbox
Our users are paranoid about phishing at this point and many report emails from other employees. Because of sensitivity of some of our information, it can’t be reported to Microsoft. So, we have to have an admin wade through all the user reported messages and weed out the ones that don’t have [External] in the subject. This wastes a lot of time for our admins. I even tried a mail flow rule to delete anything that didn’t have [External] in the subject from going to the submission mailbox and it did delete the message silently, but it still shows up in the user reported messages portal and we have to sort through it. Is there any other way to stop those messages from showing up in the portal?
PS. This wasn’t an issue until recently because we used to be able to put [External] in the name filter and it would act like a wild card, but that has stopped working.
Our users are paranoid about phishing at this point and many report emails from other employees. Because of sensitivity of some of our information, it can’t be reported to Microsoft. So, we have to have an admin wade through all the user reported messages and weed out the ones that don’t have [External] in the subject. This wastes a lot of time for our admins. I even tried a mail flow rule to delete anything that didn’t have [External] in the subject from going to the submission mailbox and it did delete the message silently, but it still shows up in the user reported messages portal and we have to sort through it. Is there any other way to stop those messages from showing up in the portal? PS. This wasn’t an issue until recently because we used to be able to put [External] in the name filter and it would act like a wild card, but that has stopped working. Read More
One Drive on Dual-Boot system – Not synching after changing OSes
We have an employee who has a Win 10 / Win 11 Dual Boot system. They switch OSes about once a week, and there’s a fair bit of change in their OneDrive for Business since the last time they loaded their “new” OS. The issue is that, after switching OSes, they have to un-link and re-link their OneDrive before it will begin to sync data. As this employee is also Visually Impaired, this is quite an annoying task for them to have to undertake once or twice a week.
I’m presuming that the underlying cause is that OneDrive is generating an App ID from the system hardware, which is resulting in both installs looking like the same instance to the server.
Is there a way to fix this so that the two installs properly sync after an OS switch?
We have an employee who has a Win 10 / Win 11 Dual Boot system. They switch OSes about once a week, and there’s a fair bit of change in their OneDrive for Business since the last time they loaded their “new” OS. The issue is that, after switching OSes, they have to un-link and re-link their OneDrive before it will begin to sync data. As this employee is also Visually Impaired, this is quite an annoying task for them to have to undertake once or twice a week. I’m presuming that the underlying cause is that OneDrive is generating an App ID from the system hardware, which is resulting in both installs looking like the same instance to the server. Is there a way to fix this so that the two installs properly sync after an OS switch? Read More
REGISTER TODAY: FY25 Microsoft Partner Launch Events | July 9 – 22
Mark your calendars and register today!
MCAPS Start | July 9-11
Join us to align on FY25 priorities that will help you empower our customers and partners through AI transformation.
MCAPS Start for Partners | July 10
Mark your calendars for the Microsoft worldwide kickoff of MCAPS Start for Partners, a digital event focused on how you can engage, build, sell, and go to market with Microsoft, and how we can drive AI transformation and growth together.
Americas Start for Partners | July 12
Join the Americas Global Partner Solutions leaders for a digital event to celebrate this past year’s success, recognize Partner of the Year winners and share insights into how we are accelerating AI opportunity and growth, empowering AI transformation for our customers and partners.
Microsoft Partner FY25 GTM Launch | July 22
Attend the event to hear about the go-to-market (GTM) priorities and initiatives Microsoft Modern Work and Business Applications have planned for FY25.
To join the event, please access one of the links below. Note: These links will not be active until 7:45am PDT the day of the event.
Build New Value with Business Applications Practices | https://aka.ms/FY25-GTM-co-sell-ba
Cloud Solution Provider Partner-Led GTM | https://aka.ms/FY25-GTM-csp
Co-Sell with Microsoft to Managed Customers | https://aka.ms/FY25-GTM-co-sell-mw
Mark your calendars and register today!
MCAPS Start | July 9-11
Join us to align on FY25 priorities that will help you empower our customers and partners through AI transformation.
REGISTER HERE
MCAPS Start for Partners | July 10
Mark your calendars for the Microsoft worldwide kickoff of MCAPS Start for Partners, a digital event focused on how you can engage, build, sell, and go to market with Microsoft, and how we can drive AI transformation and growth together.
REGISTER HERE
Americas Start for Partners | July 12
Join the Americas Global Partner Solutions leaders for a digital event to celebrate this past year’s success, recognize Partner of the Year winners and share insights into how we are accelerating AI opportunity and growth, empowering AI transformation for our customers and partners.
REGISTER TODAY
Microsoft Partner FY25 GTM Launch | July 22
Attend the event to hear about the go-to-market (GTM) priorities and initiatives Microsoft Modern Work and Business Applications have planned for FY25.
LEARN MORE
To join the event, please access one of the links below. Note: These links will not be active until 7:45am PDT the day of the event.
Build New Value with Business Applications Practices | https://aka.ms/FY25-GTM-co-sell-ba
Cloud Solution Provider Partner-Led GTM | https://aka.ms/FY25-GTM-csp
Co-Sell with Microsoft to Managed Customers | https://aka.ms/FY25-GTM-co-sell-mw Read More
Personal Teams accounts now available on Windows 10 and Mac
You can now use a personal account in the new Teams app on Windows 10 and Mac. Read more in the recent post on the Teams Insider Blog:
Personal Teams accounts now available on Windows 10 and Mac – Teams Insider – Teams for Personal
Microsoft Tech Community – Latest Blogs –Read More
Looking into implementing Geofencing / location based access
Hello fellow nerds!
I’m looking into implementing some form of geofence for our school district. We have Entra P1 for all of our users.
So far I’ve been looking into building a conditional access policy to deny all cloud apps when condition=location is NOT United states.
I have this applied in read-only mode but have not gotten any audit results back yet.
Does anyone else have a way to block sign-in attempts from countries outside of their residence? Anyone else struggled through this so I don’t have to reinvent the wheel?
I appreciate any feedback!
Hello fellow nerds!I’m looking into implementing some form of geofence for our school district. We have Entra P1 for all of our users.So far I’ve been looking into building a conditional access policy to deny all cloud apps when condition=location is NOT United states. I have this applied in read-only mode but have not gotten any audit results back yet.Does anyone else have a way to block sign-in attempts from countries outside of their residence? Anyone else struggled through this so I don’t have to reinvent the wheel? I appreciate any feedback! Read More
Way to view top External Collaborator’s email domains?
Hi Community,
Long time no post! I’m on the new Viva Insights platform and have been diving more deeply into the capabilities recently.
I seem to recall a page somewhere on the old Workplace Analytics platform that seemed to be centered around a Sales use case where it showed the top external domains with which our employees collaborated.
Is there an equivalent on the new platform where I could see the top external domains outside the company? I’ve tried a person to group query where I’ve added email domain as an attribute; however, this attribute must be coming from our org data file because every record that came back appears to be internal to the company. I do see that we have External Collaboration metrics for a Person query, but I don’t think this shows me domains.
Any ideas?!
Hi Community, Long time no post! I’m on the new Viva Insights platform and have been diving more deeply into the capabilities recently. I seem to recall a page somewhere on the old Workplace Analytics platform that seemed to be centered around a Sales use case where it showed the top external domains with which our employees collaborated. Is there an equivalent on the new platform where I could see the top external domains outside the company? I’ve tried a person to group query where I’ve added email domain as an attribute; however, this attribute must be coming from our org data file because every record that came back appears to be internal to the company. I do see that we have External Collaboration metrics for a Person query, but I don’t think this shows me domains. Any ideas?! Read More
June V2 Title NOW OUT!
MPN Partner Portal Learning Resources page Resource page for Training Services Partners
Hello, everyone —
The June Monthly Title Plan V2 is attached to this forum.
This Monthly Title Plan is also shared in:
MPN Partner Portal Learning Resources page Resource page for Training Services Partners
MCT Lounge Brand-new lounge for MCTs
Please ensure to check out the LOC Courseware updates we have made on the Title Plan. (The updates are highlighted in the Courseware news tab)
We appreciate your patience, as we worked through some technical difficulties with uploading the Title Plan.
Thank you Read More
QUE COMPU ME PUEDO COMPRAR
Estoy en un dilema sobre qué tipo de computadora comprar para mis actividades de programacion. Estoy entre una computadora gaming con buenas especificaciones de hardware y una computadora profesional más enfocada en la durabilidad y el soporte técnico.
Estoy en un dilema sobre qué tipo de computadora comprar para mis actividades de programacion. Estoy entre una computadora gaming con buenas especificaciones de hardware y una computadora profesional más enfocada en la durabilidad y el soporte técnico. Read More
How to group two shapes in Excel?
Hello,
I would like to group two shapes in my Excel spreadsheet. However, I can’t do it at all. Many tutorials indicate that you must first select a shape and then press and hold the Ctrl key and select the second shape. But it doesn’t work. I tried everything; with the SHIFT, Shift, Alt, Fn key. Nothing does it.
I work on iPad Pro but I also tried on my SAMSUM RC720 PC. but without success.
What should I do, is there something to set up?
Could you help me please.
Hello,I would like to group two shapes in my Excel spreadsheet. However, I can’t do it at all. Many tutorials indicate that you must first select a shape and then press and hold the Ctrl key and select the second shape. But it doesn’t work. I tried everything; with the SHIFT, Shift, Alt, Fn key. Nothing does it.I work on iPad Pro but I also tried on my SAMSUM RC720 PC. but without success.What should I do, is there something to set up?Could you help me please. Read More
SharePoint List display different all of a sudden?
Good afternoon,
Has any one encountered a SharePoint list that displays like this?
I work in lists all day and recently noticed that the display has changed. First, there is an icon beside the list name and the views are displayed in a tabular format rather than the drop down menu I am used to. It’s not a configured view and I’ve tried to figure out how all my lists got this way and how to get them back to ‘normal’. If this the new way, so be it, but if it isn’t I sure would like to know how they got this way. Any ideas?
Many thanks
Good afternoon,Has any one encountered a SharePoint list that displays like this? I work in lists all day and recently noticed that the display has changed. First, there is an icon beside the list name and the views are displayed in a tabular format rather than the drop down menu I am used to. It’s not a configured view and I’ve tried to figure out how all my lists got this way and how to get them back to ‘normal’. If this the new way, so be it, but if it isn’t I sure would like to know how they got this way. Any ideas? Many thanks Read More
prediction box not working correctly
the prediction box on my system isn‘t removing the word that is predicting when i select it from the box instead it writes next to it
example: writwrites
an example video :-https://www.reddit.com/user/samyqtu/comments/1dtv3lf/prediction_box_not_working_correctly
i use win 11 home beta channel
how do i fix it ?
the prediction box on my system isn’t removing the word that is predicting when i select it from the box instead it writes next to itexample: writwritesan example video :-https://www.reddit.com/user/samyqtu/comments/1dtv3lf/prediction_box_not_working_correctlyi use win 11 home beta channel how do i fix it ? Read More
Input needed
So to begin my account is very secure, yet for countless weeks maybe even months, my email address is being brute force attacked on the hourly sometimes more. The attacks are clearly from a VPN because it’s a different country and IP address each time. I’m not really sure what to do about it. Even if I took it to my local police they are notorious for inability to investigate I live in Lincolnshire which is the highest complaints to officer ratio on record in the country. I don’t know coding or anything basically more advanced than pinging an IP in windows and opening command prompt.
I have a strong hunch it is someone I know, I also had a blackmail email several months ago, but I can’t be sure it’s not some random scammer.
Is there anything I could do about this?
So to begin my account is very secure, yet for countless weeks maybe even months, my email address is being brute force attacked on the hourly sometimes more. The attacks are clearly from a VPN because it’s a different country and IP address each time. I’m not really sure what to do about it. Even if I took it to my local police they are notorious for inability to investigate I live in Lincolnshire which is the highest complaints to officer ratio on record in the country. I don’t know coding or anything basically more advanced than pinging an IP in windows and opening command prompt. I have a strong hunch it is someone I know, I also had a blackmail email several months ago, but I can’t be sure it’s not some random scammer. Is there anything I could do about this? Read More
How to I apply exceptions arc servers MDE
I can not seem to apply exclusion policies to my Defender for cloud arc enabled win2k12 servers.
So I need to create a device group in Entra for these policies to be applied ?
I can not seem to apply exclusion policies to my Defender for cloud arc enabled win2k12 servers.So I need to create a device group in Entra for these policies to be applied ? Read More
Recap: June 2024 Ambassador AI Projects Demo Day, Showcasing the Power of AI
Building with AI for Global Impact
On June 13, 2024, The Ambassador Projects Demo Day was held virtually on Teams. The event brought together rising developers from all over the world to collaborate and create innovative solutions to real-world problems.
We would like to extend our sincerest thanks to the Gold leads Aayushi Singh, Konstantinos Sitistas, Megha Vishwakarma, Hadil BenAmor, Marjan Hussein for their hard work and dedication in putting together such an amazing event and leading this past cycle of the projects program. Without their tireless efforts, this event would not have been possible. In addition, we would like to thank our Gold milestone judges, Byansi Anthony, Deepthi Balasubramanian, Meerali Naseet, Mudasir Murtaza and Subhashis Paul.
The winning team was Kairos, led by Ambassador Sarosij Ghosh Ray. Their project, Street Savvy, was chosen as the winner because of its innovative approach to solving a real-world problem. Street Savvy is an interactive simulation powered by Azure AI Services that teaches the player about the Indian traffic rules in a gamified manner. This project addresses the critical issue of road safety and driver education in India. Despite existing regulations, India continues to have one of the highest rates of traffic accidents and fatalities in the world. A major contributing factor is the lack of comprehensive understanding and adherence to traffic rules among drivers. Street Savvy tries to teach and raise awareness about Indian traffic rules and road safety in a fun and interactive way so that the youth, drivers or even kids can learn. The judges were impressed with the team’s ability to work together and create a solution that was both practical and innovative.
Other teams that participated in the Ambassadors Projects Program and made it to the final 5 round included Rhino Team, Team Matrix, Catalyst and AgriVision . Each team worked tirelessly to create innovative solutions to real-world problems. Although they did not win, their projects were impressive and showed great promise.
Rhino Team – Team Rhino is crafting an innovative Power Apps solution tailored for the more than 5000 Microsoft Learn Student Ambassadors around the world. This app not only facilitates seamless team formation but also empowers team leads to pinpoint individuals with specific skillsets and team seeker to find adequate team thanks to AI suggestions.
Team Matrix – Aims to develop a Tomato Disease Classifier App using Azure Custom Vision, Azure Web App, and Azure OpenAI Service technology. The app targets farmers and agricultural professionals, providing them with a tool for early detection and classification of common tomato diseases. Leveraging machine learning, computer vision techniques, and natural language processing, the app will assist in identifying diseases promptly, thereby enabling effective disease management and enhancing crop yield and quality.
Catalys – The Code Analysis and Vulnerability Prediction Tool automates code analysis, predicts security issues using machine learning, and offers insights and mitigation strategies to developers.
AgriVision – The 2018 Kerala floods in India were a significant natural disaster caused by unprecedented monsoon rainfall, severely impacting the agricultural sector. This project aims to assess the impact of these floods on agricultural productivity using Normalized Difference Vegetation Index (NDVI) data. By analyzing NDVI data, we aim to provide insights into the extent of agricultural damage and recovery post-flood. The results will help local communities and policymakers improve disaster preparedness, response strategies, and agricultural planning.
Overall, this cycle of Ambassador Projects was a huge success. The event brought together some of the brightest minds in the industry and showcased some truly innovative solutions to real-world problems. We look forward to seeing what the future holds for these talented developers.
Learn more about the Microsoft Learn Student Ambassadors program here.
Microsoft Tech Community – Latest Blogs –Read More
Trying to add month and year labels underneath week numbers along x-axis in Excel graph
I have data throughout many years and am plotting them by week
But I would like to add a month and year label underneath the week number like this example from https://community.fabric.microsoft.com/t5/Desktop/Graph-showing-x-weeks-rolling-data-over-multiple-years/td-p/2295281:
Unlike the example, I would prefer it if the week number didn’t start from 1 again in a new year.
Is there any way to accomplish this without Power BI? Or with Power BI Free Trial version on browser? I would greatly appreciate some help.
I have data throughout many years and am plotting them by week But I would like to add a month and year label underneath the week number like this example from https://community.fabric.microsoft.com/t5/Desktop/Graph-showing-x-weeks-rolling-data-over-multiple-years/td-p/2295281:Unlike the example, I would prefer it if the week number didn’t start from 1 again in a new year. Is there any way to accomplish this without Power BI? Or with Power BI Free Trial version on browser? I would greatly appreciate some help. Read More