Tag Archives: microsoft
Microsoft will require MFA for all Azure users
This July, Azure teams will begin rolling out additional tenant-level security measures to require multi-factor authentication (MFA). Establishing this security baseline at the tenant level puts in place additional security to protect your cloud investments and company.
MFA is a security method commonly required among cloud service providers and requires users to provide two or more pieces of evidence to verify their identity before accessing a service or a resource. It adds an extra layer of protection to the standard username and password authentication.
The roll-out of this requirement will be gradual and methodical to minimize impact on your use cases. The blog post below provides helpful information from the Azure product team to assist you in getting ready to MFA-enable your access to Azure services. Going forward, the team will provide communications to you about your specific roll-out dates through direct emails and Azure Portal notifications. Expect these in the coming months.
Read on to learn why and how MFA is important to securing customers on Azure and your workloads, environments, and users.
If you do not wait to wait for the roll-out, set up MFA now with the MFA wizard for Microsoft Entra.
– Erin
How MFA works
Multi-factor authentication (MFA) is a security method that requires users to provide two or more pieces of evidence to verify their identity before accessing a service or a resource. The evidence can be something the user knows (such as a password or a PIN), something the user has (such as a phone or a token), or something the user is (such as a fingerprint or a face scan).
MFA adds an extra layer of protection to the standard username and password authentication, making it harder for attackers to compromise accounts and steal data. MFA can also help prevent unauthorized access due to phishing, credential stuffing, brute force, or password reuse attacks.
Entra ID supports various MFA methods, such as Microsoft Authenticator app, SMS, voice call, and hardware tokens. Users can choose the method that suits their preferences and needs. Admins can also use Entra ID Conditional Access policies to tune when MFA is required based on signals such as the user’s location, device, role, or risk level.
Why MFA is important for Azure tenant security
The need for MFA is more important than ever, as cyberattacks are becoming more frequent, sophisticated, and damaging. According to a report by Microsoft, 99.9% of compromised accounts did not use MFA. The report also found that MFA can block more than 99.2% of account compromise attacks, making it one of the most effective security measures available. As noted in the report, MFA can block more than 99.9% of account compromise attacks, making it one of the most effective security measures available.
The rise of the hybrid workforce and accelerated digital transformation of businesses by the COVID-19 pandemic expanded risk scenarios for employees and companies. Today, more people work outside of the office and access data and applications from various devices and locations. All of this has increased the attack surface and the potential for unauthorized access, as users may use unsecured networks, devices, or passwords. MFA can help mitigate these risks by adding an extra verification step and preventing access from unknown or suspicious sources.
MFA is also a key component of identity and access management, which involves ensuring that only authorized and authenticated users can access the services and resources. One of the three areas of engineering advancements within Microsoft’s Secure Future Initiative focuses on implementing new identity protections and MFA at the tenant level helps you with identity protections. MFA not only reduces the risk of account compromise and data breach, but it also helps you comply with various security standards and regulations, such as PCI DSS, HIPAA, GDPR, and NIST.
Don’t wait to set up MFA
To help you keep users and data safe, MFA is now available and free for you to enable at the tenant level. You can set up MFA today with the MFA wizard for Microsoft Entra.
If you have additional questions, please review the MFA FAQ on Microsoft Learn for more information and learn more about the Secure Future Initiative and Microsoft’s built-in security features here.
Microsoft Tech Community – Latest Blogs –Read More
Project for the Web Roadmap Visualisation
We have just start to use this solution and noticing that on some project added to the roadmap that the first task selected to be displayed is not shown in the designed order, even though the entered dates and order of tasks should have it displayed at the top of the added roadmap entry. This makes for a messy visualisation of the created roadmap entry and reduces its value.
We have recreated entries in the roadmap, and even the roadmap itself and still have the experience.
Keen to understand if anyone else is having the same experience and whether this is a known issue with the solution?
We have just start to use this solution and noticing that on some project added to the roadmap that the first task selected to be displayed is not shown in the designed order, even though the entered dates and order of tasks should have it displayed at the top of the added roadmap entry. This makes for a messy visualisation of the created roadmap entry and reduces its value. We have recreated entries in the roadmap, and even the roadmap itself and still have the experience. Keen to understand if anyone else is having the same experience and whether this is a known issue with the solution? Read More
Sumifs and Dates
I am trying to use the SUMIFS function but am unsure how to include the day and month as one of the criteria. I tried “5/1-5/31” and even listed all the days and set it as “K1:K30” but neither works.
I am trying to use the SUMIFS function but am unsure how to include the day and month as one of the criteria. I tried “5/1-5/31” and even listed all the days and set it as “K1:K30” but neither works. Read More
Copying date from one sheet to another sheet using script.
I am using power automate to create a PDF of a worksheet and email to someone. Now the worksheet if populated by formulas. Therefore, when power automate pulls the worksheet to creat a PDF the data doesn’t come with it.
So I figured no big deal, i’ll just create a script that will copy the formula filled data to paste the values and formating to another worksheet.
Well, after banging my head agains the wall for about 3 hours, I can’t seem to get it to work.
I was able to come up with this using the record actions button.
function main(workbook: ExcelScript.Workbook) {
let report8453 = workbook.getWorksheet(“Report8453”);
let selectedSheet = workbook.getActiveWorksheet();
// Paste to all cells on report8453 from all cells on selectedSheet
report8453.getRange().copyFrom(selectedSheet.getRange(), ExcelScript.RangeCopyType.values, false, false);
// Paste to all cells on report8453 from all cells on selectedSheet
report8453.getRange().copyFrom(selectedSheet.getRange(), ExcelScript.RangeCopyType.formats, false, false);
}
But what I found out real fast is that this only works with what ever worksheet you are currently looking at. So if you don’t watch it, you’ll copy and paste to the wrong worksheet and also find out real fast there is no undo.
So after going back and restoring to an orginal version of what I am looking at. I came up with this.
function main(workbook: ExcelScript.Workbook) {
let Tn8453 = workbook.getWorksheet(“Tn8453”);
let report8453 = workbook.getWorksheet(“Report8453”);
// Paste to all cells on report8453 from all cells on selectedSheet
report8453.getRange(“A1:D18”).copyFrom(Tn8453.getRange(“A1:D18”), ExcelScript.RangeCopyType.values, false, false);
// Paste to all cells on report8453 from all cells on selectedSheet
report8453.getRange(“A1:D18”).copyFrom(Tn8453.getRange(“A1:D18”), ExcelScript.RangeCopyType.formats, false, false);
}
This is the code that I came up with, and it worked for about 2 min, then started getting an error.
Line 5: Range copyFrom: There was an internal error while processing the request.
What I thought I was doing was telling it to go to worksheet Tn8453 and copy those cells, and then pasting what I needed. But still get the error above.
Now at the very least, I just manully did what I wanted, and it came out looking great.
Is there something missing?
Thank you for your help.
Chip
I am using power automate to create a PDF of a worksheet and email to someone. Now the worksheet if populated by formulas. Therefore, when power automate pulls the worksheet to creat a PDF the data doesn’t come with it. So I figured no big deal, i’ll just create a script that will copy the formula filled data to paste the values and formating to another worksheet. Well, after banging my head agains the wall for about 3 hours, I can’t seem to get it to work. I was able to come up with this using the record actions button. function main(workbook: ExcelScript.Workbook) {
let report8453 = workbook.getWorksheet(“Report8453”);
let selectedSheet = workbook.getActiveWorksheet();
// Paste to all cells on report8453 from all cells on selectedSheet
report8453.getRange().copyFrom(selectedSheet.getRange(), ExcelScript.RangeCopyType.values, false, false);
// Paste to all cells on report8453 from all cells on selectedSheet
report8453.getRange().copyFrom(selectedSheet.getRange(), ExcelScript.RangeCopyType.formats, false, false);
} But what I found out real fast is that this only works with what ever worksheet you are currently looking at. So if you don’t watch it, you’ll copy and paste to the wrong worksheet and also find out real fast there is no undo. So after going back and restoring to an orginal version of what I am looking at. I came up with this. function main(workbook: ExcelScript.Workbook) {
let Tn8453 = workbook.getWorksheet(“Tn8453”);
let report8453 = workbook.getWorksheet(“Report8453”);
// Paste to all cells on report8453 from all cells on selectedSheet
report8453.getRange(“A1:D18”).copyFrom(Tn8453.getRange(“A1:D18”), ExcelScript.RangeCopyType.values, false, false);
// Paste to all cells on report8453 from all cells on selectedSheet
report8453.getRange(“A1:D18”).copyFrom(Tn8453.getRange(“A1:D18”), ExcelScript.RangeCopyType.formats, false, false);
} This is the code that I came up with, and it worked for about 2 min, then started getting an error. Line 5: Range copyFrom: There was an internal error while processing the request. What I thought I was doing was telling it to go to worksheet Tn8453 and copy those cells, and then pasting what I needed. But still get the error above. Now at the very least, I just manully did what I wanted, and it came out looking great. Is there something missing? Thank you for your help.Chip Read More
Embedded workbook Dropdown list not Working
Hi everyone,
I have a workbook with multiple dropdowns embedded from onedrive into our website as an IFrame.
All was working prefect till about 10 May when all the dropdowns stopped working (no arrow and no values)
If I open it in onedrive or desktop, everything works perfectly.
What I’ve tried so far with no success:
1. Confirmed embedded code has “AllowTyping=True”.
2. Scroll lock is not on (think this would be issue on desktop app)
3. Advance/Display options: For Objects, Show “ALL” is selected.
4. Document is not corrupted: Re did the whole document from scratch with updated Data validation lists from only a single sheet (previous was from multiple sheets)
5. Same issue in Chrome & Edge. Requested friends and work colleagues to try on their PC’s with all having the same issue with the dropdowns.
I have noticed when embedding in onedrive at “customize how this embedded workbook will appear….” as soon as I “view actual size” the dropdowns disappear, same as the Iframe in the website.
This is from a public site so not sure if I’m allowed to share the site link or even the embedded code?
Please help as this was suppose to be for a product launch on Monday but due to this everything is on hold.
Any help will be appreciated!
Link to our Site:
Embedded Excel Calculator in our Website
Hi everyone, I have a workbook with multiple dropdowns embedded from onedrive into our website as an IFrame.All was working prefect till about 10 May when all the dropdowns stopped working (no arrow and no values)If I open it in onedrive or desktop, everything works perfectly.What I’ve tried so far with no success:1. Confirmed embedded code has “AllowTyping=True”.2. Scroll lock is not on (think this would be issue on desktop app)3. Advance/Display options: For Objects, Show “ALL” is selected.4. Document is not corrupted: Re did the whole document from scratch with updated Data validation lists from only a single sheet (previous was from multiple sheets)5. Same issue in Chrome & Edge. Requested friends and work colleagues to try on their PC’s with all having the same issue with the dropdowns. I have noticed when embedding in onedrive at “customize how this embedded workbook will appear….” as soon as I “view actual size” the dropdowns disappear, same as the Iframe in the website. This is from a public site so not sure if I’m allowed to share the site link or even the embedded code?Please help as this was suppose to be for a product launch on Monday but due to this everything is on hold.Any help will be appreciated!Link to our Site:Embedded Excel Calculator in our Website Read More
Outlook deleting forwarded email
We have 4 email accounts that end in *name.onmicrosoft.com that is used for teams account. When we forward a meeting invite to those accounts, it automatically gets sent to trash folder. We looked at setting on outlook.com but can’t seem to get it to stay in inbox. Kind of lost where to look next.
Would there be a setting in our microsoft365 account or azure account that we could check for?
send and receiving emails works as it should but its only when we forward an invite to those address, it automatically gets deleted.
any help would be appreciated.
Thank you!
We have 4 email accounts that end in *name.onmicrosoft.com that is used for teams account. When we forward a meeting invite to those accounts, it automatically gets sent to trash folder. We looked at setting on outlook.com but can’t seem to get it to stay in inbox. Kind of lost where to look next. Would there be a setting in our microsoft365 account or azure account that we could check for?send and receiving emails works as it should but its only when we forward an invite to those address, it automatically gets deleted. any help would be appreciated.Thank you! Read More
Insurance spreadsheet
Hi
I am trying to get the spreadsheet to give a sum of zero in the cell if the formula sums to a negative number or keep the positive number if it is greater than 0.
I am solving for how much the insurance company will pay.
Scenario-
If the Amt billed to insurance is <Deductible then the patient will pay
If the Amt billed to insurance is >Deductible then Insurance will pay the amount over the deductible-coinsurance.
After the deductible is paid by the patient, then they will owe the coinsurance % for the amount over the deductible and the insurance will pay the balance.
Example
$1357 billed to insurance
$500 Deductible 20% coinsurance
$1357-500 (pt amount of Ded)
$857 * 20% coinsurance =$171.40
Patient would pay $500 ded and $171.40 coinsurance for total of $671.40.
Insurance would pay $685.60
If the Deductible was $5000 then $1357 would be billed and it would all be patient deductible.
I cannot figure out how to make my spreadsheet work!
Insurance Covered ServicesUnits CostTotal Billed AmountCODEIns Units AETNATotal Contractual AmountRe-exams2 $65.00$130.0099212 $36.61$73.22Manipulations 1-2 reg0 $55.00$0.0098940 $24.56$0.00Manipulations 3-4 reg18 $65.00$1,170.0098941 $34.28$617.04Extra Spinal0 $38.00$0.0098943 $23.06$0.00Estim22 $30.00$0.0097014 $13.28$0.00Traction18 $33.00$594.0097012 $13.82$248.76 Rehab16 $30.00$480.0097110 $26.14$418.24 $2,374.00 $1,357.26Total Insurance Billed Amount $1,357.26Insurance Contractual $1,357.26Estimated Insurance Adjustment $1,016.74Noncovered Services Cash Manipulations3 $60.00$180.00 Cash Re-exam3 $50.00$150.00 Cash Rehab 0 $20.00$0.00 Cash Acupuncture/Dry Needling0 $60.00$0.00 Cash Decompression0 $60.00$0.00 SoftWave0 $ – $0.00 Total Noncovered Services $330.00 Total Insurance and Noncovered Services $1,687.26Deductible to be met: $500.00Services after deductible $0.00Coinsurance 20.00% $171.45Copays $0.00 $0.00Estimated insurance payment $685.81Estimated Patient Balance $1,001.45
HiI am trying to get the spreadsheet to give a sum of zero in the cell if the formula sums to a negative number or keep the positive number if it is greater than 0.I am solving for how much the insurance company will pay. Scenario-If the Amt billed to insurance is <Deductible then the patient will payIf the Amt billed to insurance is >Deductible then Insurance will pay the amount over the deductible-coinsurance. After the deductible is paid by the patient, then they will owe the coinsurance % for the amount over the deductible and the insurance will pay the balance.Example$1357 billed to insurance$500 Deductible 20% coinsurance$1357-500 (pt amount of Ded)$857 * 20% coinsurance =$171.40Patient would pay $500 ded and $171.40 coinsurance for total of $671.40. Insurance would pay $685.60 If the Deductible was $5000 then $1357 would be billed and it would all be patient deductible. I cannot figure out how to make my spreadsheet work! Insurance Covered ServicesUnits CostTotal Billed AmountCODEIns Units AETNATotal Contractual AmountRe-exams2 $65.00$130.0099212 $36.61$73.22Manipulations 1-2 reg0 $55.00$0.0098940 $24.56$0.00Manipulations 3-4 reg18 $65.00$1,170.0098941 $34.28$617.04Extra Spinal0 $38.00$0.0098943 $23.06$0.00Estim22 $30.00$0.0097014 $13.28$0.00Traction18 $33.00$594.0097012 $13.82$248.76 Rehab16 $30.00$480.0097110 $26.14$418.24 $2,374.00 $1,357.26Total Insurance Billed Amount $1,357.26Insurance Contractual $1,357.26Estimated Insurance Adjustment $1,016.74Noncovered Services Cash Manipulations3 $60.00$180.00 Cash Re-exam3 $50.00$150.00 Cash Rehab 0 $20.00$0.00 Cash Acupuncture/Dry Needling0 $60.00$0.00 Cash Decompression0 $60.00$0.00 SoftWave0 $ – $0.00 Total Noncovered Services $330.00 Total Insurance and Noncovered Services $1,687.26Deductible to be met: $500.00Services after deductible $0.00Coinsurance 20.00% $171.45Copays $0.00 $0.00Estimated insurance payment $685.81Estimated Patient Balance $1,001.45 Read More
Upcoming May 2023 Microsoft 365 Champion Community Call
Join our next community call on May 28 to deep dive into the Copilot for Microsoft 365 Success Kit. We will be starting the call at 5 minutes past the hour for both of our sessions (at 8:05 AM and 5:05 PM PT), and it will still end at the top of the hour (9:00 AM and 6:00 PM PT, respectively).
If you have not yet joined our Champion community, sign up here to get access to the calendar invites, program assets, and previous call recordings.
Microsoft Tech Community – Latest Blogs –Read More
Consolidated Recommendation API Phase 1
We are pleased to announce the release of Phase 1 of our new Consolidated Recommendation API.
The Consolidated Recommendation API introduces a unified interface structure that enables developers to retrieve, apply, or dismiss recommendations in a unified pattern. Instead of requiring individual API calls for each new recommendation, this pipeline will surface any current and new recommendations with a single implementation.
This release supports budget, keyword, and responsive search ads recommendations. Get recommendations with a single service operation RetrieveRecommendations, and apply them with ApplyRecommendations.
Key Features
No need to code each recommendation separately.
Work with current and new recommendations in a single implementation.
Reduce developer effort.
Easier integration of systems with Microsoft Advertising recommendations.
New API Interfaces
Ad Insight API
ApplyRecommendationEntity, ApplyRecommendations, BudgetPointType, CampaignBudgetRecommendation, DismissRecommendationEntity, DismissRecommendations, KeywordRecommendation, RecommendationBase, RecommendationType, ResponsiveSearchAdRecommendation, RetrieveRecommendations.
Learn more about the Micrsoft Advertising Ad Insight API service operations.
Microsoft Tech Community – Latest Blogs –Read More
New Blog | Microsoft Teams DLP Playbook
May 2024 Edition
We’re so excited to publish the updated Teams DLP Playbook!
This document provides an overview of how enterprise customers can deploy Microsoft Teams-DLP for protecting sensitive information. Microsoft Purview Data Loss Prevention has integrations with multiple workloads that help to protect customer data with a single policy. Teams DLP is one of the workloads within Microsoft Purview Data Loss Prevention. This guide walks through the different aspects of deploying use cases across content/containers.
Get the full book here: Microsoft Teams DLP Playbook
By Sarahzin Shane
May 2024 Edition
We’re so excited to publish the updated Teams DLP Playbook!
This document provides an overview of how enterprise customers can deploy Microsoft Teams-DLP for protecting sensitive information. Microsoft Purview Data Loss Prevention has integrations with multiple workloads that help to protect customer data with a single policy. Teams DLP is one of the workloads within Microsoft Purview Data Loss Prevention. This guide walks through the different aspects of deploying use cases across content/containers.
Get the full book here: Microsoft Teams DLP Playbook
Unable to access Meeting Recordings
Hi, realising that we missed the deadline to migrate videos from Stream Classic to Stream sharepoint. I see where some videos were selectively migrated however some in a specifiy period has not been, is there any way to still access these recordings to be able to do the migration before the complete shutdown of the platform?
Hi, realising that we missed the deadline to migrate videos from Stream Classic to Stream sharepoint. I see where some videos were selectively migrated however some in a specifiy period has not been, is there any way to still access these recordings to be able to do the migration before the complete shutdown of the platform? Read More
Can’t change channel name
Hi. I made a new channel within my organization’s Teams and deleted it because I needed to make it a public channel rather than private. I tried to create it a second time as a public channel, but I got an error. The error seems to specifically be with the name, because I was able to create a public “Test” channel and replicated the error when I deleted that channel and tried to make it again or change the name of “Test1” to just “Test.” I can change it to other things, but not the two names I’ve used and deleted.
I’ve searched SharePoint’s recycle bin and cleared out app data from Teams but am still having the issue. It says “We ran into a problem editing your channel.” Please let me know if I can fix this somehow.
Hi. I made a new channel within my organization’s Teams and deleted it because I needed to make it a public channel rather than private. I tried to create it a second time as a public channel, but I got an error. The error seems to specifically be with the name, because I was able to create a public “Test” channel and replicated the error when I deleted that channel and tried to make it again or change the name of “Test1” to just “Test.” I can change it to other things, but not the two names I’ve used and deleted. I’ve searched SharePoint’s recycle bin and cleared out app data from Teams but am still having the issue. It says “We ran into a problem editing your channel.” Please let me know if I can fix this somehow. Read More
Teams Notification when Outlook Email Sent
Hello,
I am looking for a way to send a teams alert to a recipient when that recipient receives an email from a specific sender. Is there any way to do this? I’ve looked at Outlook rules and found nothing but I could’ve missed something.
Thanks
Hello, I am looking for a way to send a teams alert to a recipient when that recipient receives an email from a specific sender. Is there any way to do this? I’ve looked at Outlook rules and found nothing but I could’ve missed something. Thanks Read More
New Blog | Meet us at Identiverse: May 28-31 in Las Vegas
The annual Identiverse conference is a great opportunity to meet with our community, immerse in the latest challenges and innovations, and hear from leaders in the identity industry. And it’s happening soon! Identiverse 2024 is taking place from May 28 to 31 in Las Vegas, Nevada at ARIA Resort & Casino.
By attending, you’ll be among the first to hear about what’s new with Microsoft Entra, our work in identity standards, and how it will help you navigate the constantly evolving identity and network access threat landscape.
Plus, you can request a 1:1 meeting with a Microsoft identity expert and drop by Booth #2423 in the expo hall to ask questions and see the latest demos of identity solutions and Microsoft Copilot for Security.
Featured Microsoft sessions at Identiverse
We’ve got a powerhouse lineup of topics showcasing our latest innovations to help you get the most from Microsoft Entra.
During our session, Secure access for any trustworthy identity, anywhere, to anything, on Wednesday, May 29 at 2:00 PM, we’ll update you on Microsoft’s progress to enabling the trust fabric, our vision for how organizations can secure every digital interaction from today into the future. Understanding that a Zero Trust approach to identity security is an ongoing journey, we’ll talk about four focus areas to consider and prioritize, including strengthening your identity foundation, securing access for your workforce and external identities, and securing access in multicloud.
Read the full post here: Meet us at Identiverse: May 28-31 in Las Vegas
By Nichole Peterson (SHE/HER)
The annual Identiverse conference is a great opportunity to meet with our community, immerse in the latest challenges and innovations, and hear from leaders in the identity industry. And it’s happening soon! Identiverse 2024 is taking place from May 28 to 31 in Las Vegas, Nevada at ARIA Resort & Casino.
By attending, you’ll be among the first to hear about what’s new with Microsoft Entra, our work in identity standards, and how it will help you navigate the constantly evolving identity and network access threat landscape.
Plus, you can request a 1:1 meeting with a Microsoft identity expert and drop by Booth #2423 in the expo hall to ask questions and see the latest demos of identity solutions and Microsoft Copilot for Security.
Featured Microsoft sessions at Identiverse
We’ve got a powerhouse lineup of topics showcasing our latest innovations to help you get the most from Microsoft Entra.
During our session, Secure access for any trustworthy identity, anywhere, to anything, on Wednesday, May 29 at 2:00 PM, we’ll update you on Microsoft’s progress to enabling the trust fabric, our vision for how organizations can secure every digital interaction from today into the future. Understanding that a Zero Trust approach to identity security is an ongoing journey, we’ll talk about four focus areas to consider and prioritize, including strengthening your identity foundation, securing access for your workforce and external identities, and securing access in multicloud.
Read the full post here: Meet us at Identiverse: May 28-31 in Las Vegas
Changes in how MFA frequency is Determined?
Recently a couple of my users began reporting a significant increase in the frequency in which they are required to re-authenticate. When prompted for ‘Stay Signed In’, they respond ‘yes’. Despite this, they are being asked to sign-in much more frequently than our policy states.
I don’t believe we have changed any relevant policy parameters, and so has anything changed in how sign-in frequency is determined?
Recently a couple of my users began reporting a significant increase in the frequency in which they are required to re-authenticate. When prompted for ‘Stay Signed In’, they respond ‘yes’. Despite this, they are being asked to sign-in much more frequently than our policy states. I don’t believe we have changed any relevant policy parameters, and so has anything changed in how sign-in frequency is determined? Read More
About what’s new with Postgres at Microsoft, 2024 edition
Just published this brand new blog post to share highlights of all the Azure & the open source work done by the Postgres team at Microsoft over the last 8 months. The title: What’s new with Postgres at Microsoft, 2024 edition.
The post contains a detailed infographic (handmade) that gives you a visual outline of all the different Postgres workstreams our engineering & PM teams have been driving.
And because the Postgres 17 code freeze just happened last month, I included highlights from some of the new PG17 capabilities our Postgres contributor team worked on as well.
If you’re an Azure Database for PostgreSQL – Flexible Server customer, you won’t be disappointed. Lots of new features rolled out in the last 8 months.
Just published this brand new blog post to share highlights of all the Azure & the open source work done by the Postgres team at Microsoft over the last 8 months. The title: What’s new with Postgres at Microsoft, 2024 edition. The post contains a detailed infographic (handmade) that gives you a visual outline of all the different Postgres workstreams our engineering & PM teams have been driving. And because the Postgres 17 code freeze just happened last month, I included highlights from some of the new PG17 capabilities our Postgres contributor team worked on as well. If you’re an Azure Database for PostgreSQL – Flexible Server customer, you won’t be disappointed. Lots of new features rolled out in the last 8 months. Read More
Help creating a training matrix! Please
Hi everyone,
I hope someone can help me out.
I’m wanting to creat a spreadsheet that acts as a training matrix, for the staff in my team.
What I would like to do is list what training staff have undertaken – when they finished the course and when the qualification expires.
However! I’d love to be able to have the cells change colour depending on how much time they have left before that qualification expires.
For example, if a qualification expires in a month then cell turns orange.
Or if there is over 6 months before it expires, the cell stays green.
So essentially the cell changes according to how much time you have left.
Hopefully that makes sense.
Does anyone have any smart ideas or suggestions?
Many, many thanks in advance!!
Hi everyone, I hope someone can help me out.I’m wanting to creat a spreadsheet that acts as a training matrix, for the staff in my team. What I would like to do is list what training staff have undertaken – when they finished the course and when the qualification expires. However! I’d love to be able to have the cells change colour depending on how much time they have left before that qualification expires. For example, if a qualification expires in a month then cell turns orange.Or if there is over 6 months before it expires, the cell stays green.So essentially the cell changes according to how much time you have left. Hopefully that makes sense.Does anyone have any smart ideas or suggestions? Many, many thanks in advance!! Read More
New Teams on Mac – Blank/Black Text
Sometimes, when opening teams, all text is either blank (non-existent) or shows up as black boxes.
Version below:
Sometimes, when opening teams, all text is either blank (non-existent) or shows up as black boxes. Version below: Read More
Need formula for help Excel
Same data in different columns has to be come to one column against the cell
Please find the example in attachment
Same data in different columns has to be come to one column against the cellPlease find the example in attachment Read More
table set up for mail merge
Hello,
Bottom Line Up Front:
I am attempting to set up an Excel sheet to use as the Merge Fields for a mail merge.
Background:
I have over 2300 supervisors at varying levels of experience that need the appropriate level of training. I pull a report from our data bank and save as an Excel sheet. From this data, i am trying to mine the length of time the supervisor has been in their position – Based on their start date and send the notifications accordingly.
First, I added a column for length of years and used this formula =DAYS(NOW(),F2)/365 and moved the decimal down to 2, e.g., “0.12”, to help me see if they are in the ranges i need; e.g., less than 1 year, between first and third year, and then the three and over years of experience. – this formula works fine.
Next, to initiate a mail merge to send mass invitations to the different training levels required by their experience, i added another column as “Subject” and used this formula
=IF(H2<1,”Priority”,IF(H2=1.1>=2.9,”CatchUp”,IF(H2>3,”Refresher”)))
the “Priority” and “CatchUp” work as i have hoped; however, the 1st Challenge – the “Refresher” does not ( i get no “Refresher” results). To further this challenge, i later discovered some people are on probation and some are not (because they previously held a supervisory position and did not need to redo it, yet they are in a new supervisory position) – so challenge #2 is to fix the above subject formula to include if there is a date in the Probation column to make this a “Priority” // also, if it does not have a date, to make this a “Catch Up”. #3 once i get these formulas fixed, is it possible to change the formatting to highlight Priority as Red, CatchUp as Orange, and Refresher as light green?
The next phase of the mail merge is to establish a body column – which i have not even attempted yet… Nevertheless, i am hoping that as the Subject Column is corrected that a NEW column of “Body” will reflect accordingly with:
“Priority = You are identified in HR Smart as a New Supervisor still on probation; Please, see the attachment to register. ” for
“CatchUp = You are identified in HR Smart as a Supervisor within your first and second years of experience; Please, see the attachment to register.” and finally, for
“Refresher = You are identified in HR Smart as a Seasoned Supervisor; Please, see the attachment to register.”
Can you help me fix/establish the formulas Please, so that i can then continue building the Mail Merge portion?
here is a screen shot to help you visualize this challenge:
Thank you in advance for even offering to help me.
v/r,
dave
Hello, Bottom Line Up Front:I am attempting to set up an Excel sheet to use as the Merge Fields for a mail merge. Background:I have over 2300 supervisors at varying levels of experience that need the appropriate level of training. I pull a report from our data bank and save as an Excel sheet. From this data, i am trying to mine the length of time the supervisor has been in their position – Based on their start date and send the notifications accordingly. First, I added a column for length of years and used this formula =DAYS(NOW(),F2)/365 and moved the decimal down to 2, e.g., “0.12”, to help me see if they are in the ranges i need; e.g., less than 1 year, between first and third year, and then the three and over years of experience. – this formula works fine. Next, to initiate a mail merge to send mass invitations to the different training levels required by their experience, i added another column as “Subject” and used this formula =IF(H2<1,”Priority”,IF(H2=1.1>=2.9,”CatchUp”,IF(H2>3,”Refresher”)))the “Priority” and “CatchUp” work as i have hoped; however, the 1st Challenge – the “Refresher” does not ( i get no “Refresher” results). To further this challenge, i later discovered some people are on probation and some are not (because they previously held a supervisory position and did not need to redo it, yet they are in a new supervisory position) – so challenge #2 is to fix the above subject formula to include if there is a date in the Probation column to make this a “Priority” // also, if it does not have a date, to make this a “Catch Up”. #3 once i get these formulas fixed, is it possible to change the formatting to highlight Priority as Red, CatchUp as Orange, and Refresher as light green? The next phase of the mail merge is to establish a body column – which i have not even attempted yet… Nevertheless, i am hoping that as the Subject Column is corrected that a NEW column of “Body” will reflect accordingly with:”Priority = You are identified in HR Smart as a New Supervisor still on probation; Please, see the attachment to register. ” for”CatchUp = You are identified in HR Smart as a Supervisor within your first and second years of experience; Please, see the attachment to register.” and finally, for”Refresher = You are identified in HR Smart as a Seasoned Supervisor; Please, see the attachment to register.” Can you help me fix/establish the formulas Please, so that i can then continue building the Mail Merge portion?here is a screen shot to help you visualize this challenge: Thank you in advance for even offering to help me.v/r,dave Read More