Tag Archives: microsoft
Refresh data using Power Query’s From Folder connector in Excel for Mac
Hi, Microsoft 365 Insiders,
Great news for Excel for Mac users! We are happy to announce a new feature that makes your data management even smoother. You can now refresh data using Power Query’s From Folder connector in Excel for Mac. This update allows you to effortlessly keep your data current and organized. Check out our latest blog by Gal Zivoni, Product Manager on the Excel team: Refresh data using Power Query’s From Folder connector in Excel for Mac
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Hi, Microsoft 365 Insiders,
Great news for Excel for Mac users! We are happy to announce a new feature that makes your data management even smoother. You can now refresh data using Power Query’s From Folder connector in Excel for Mac. This update allows you to effortlessly keep your data current and organized. Check out our latest blog by Gal Zivoni, Product Manager on the Excel team: Refresh data using Power Query’s From Folder connector in Excel for Mac
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android Read More
SFTP enabled Storage Account Behind Nginx Reverse Proxy
I am trying to put SFTP enabled storage Account behind nginx proxy.
I tried with the below configuration in nginx.conf
nginx service won’t restart as port 22 is already in use for SSH.
Can someone help me?
I am trying to put SFTP enabled storage Account behind nginx proxy. I tried with the below configuration in nginx.confstream { upstream backend{ server <<storageAccount_private_ip>>:22; } server {listen 22; proxy_pass backend; }}nginx service won’t restart as port 22 is already in use for SSH. Can someone help me? Read More
Elevate search operations and streamline AI development with Cohere Rerank on Azure AI
At Microsoft Build, we announced the availability of Command R models on Azure AI. Today, we are very excited to announce the addition of two new models from Cohere:
Cohere Rerank 3 – Multilingual
Cohere Rerank 3 is considered a leading AI model for semantic reranking in search systems. These models are available as serverless APIs with pay-as-you-go token-based billing. Accessing Cohere’s enterprise-ready language models on Azure AI’s robust infrastructure enables businesses to seamlessly, reliably, and safely incorporate cutting-edge semantic search technology into their applications.
This integration allows users to leverage the flexibility and scalability of Azure AI, combined with Cohere’s language models, to deliver superior search results in production. Using Azure’s AI model catalog, and with just a few lines of code, developers can implement Rerank 3 to enhance their existing search systems.
According to Cohere, Rerank 3 offers state-of-the-art capabilities for enterprise search, including:
4k context length to significantly improve search quality for longer documents
Ability to search over multi-aspect and semi-structured data like emails, invoices, JSON documents, code, and tables
Multilingual coverage of 100+ languages
Improved latency and lower total cost of ownership (TCO)
How Customers Can Enhance Search with Rerank
Rerank models (compatible with 100+ languages) serve two primary purposes,
It can be added to existing search systems after an initial dense retrieval stage to improve the relevancy of results, or
it can be added to retrieval-augmented generation (RAG) systems to increase the relevancy of documents being passed to the generative model (and therefore reduce operating costs).
Atomicwork, a digital workplace experience platform and longtime Azure customer, has significantly enhanced its IT service management platform with Rerank 3. By integrating the model into their AI digital assistant, Atom AI, Atomicwork saw over 20% in improved search accuracy and relevance, providing faster, more precise answers to complex IT support queries. This integration has streamlined IT operations and boosted productivity across the enterprise.
“The driving force behind Atomicwork’s digital workplace experience solution is Cohere’s Rerank model and Azure AI Studio, which powers Atom AI, our digital assistant, with the precision and performance required to deliver real-world results. This strategic collaboration underscores our commitment to providing businesses with advanced, secure, and reliable enterprise AI capabilities,” said Vijay Rayapati, CEO of Atomicwork.”
TD Bank Group, one of the largest banks in North America, recently signed an agreement with Cohere to explore its full suite of large language models (LLMs), including Rerank 3.
“At TD, we’ve seen the transformative potential of AI to deliver more personalized and intuitive experiences for our customers, colleagues and communities,” said Kirsti Racine, VP, AI Technology Lead, TD. “We’re excited to be working alongside Cohere to explore how its language models perform on Microsoft Azure to help support our innovation journey at the Bank.”
Enterprises of any size and in any industry can leverage Rerank to enhance their search capabilities across countless scenarios, including:
Legacy search improvement: Improve results from legacy lexical or semantic tools
Customer support search: Enable self-serve across complex customer support docs
Multilingual search: Understand meaning and relevance across over 100 languages
RAG: Retrieve most relevant answers across heterogenous enterprise data sources
Command R+, Cohere’s flagship generative model which is also available on Azure AI, is purpose-built to work well with Rerank within a RAG system. Together, they are capable of serving the most demanding enterprise workloads in production.
Boosting Search Quality for 100+ Languages with a Single Line of Code
Established keyword-based search systems are deeply ingrained within a company’s information architecture, and switching to a vector database for embedding-based search is often impractical. This is where Cohere Rerank can help, providing a seamless bridge between traditional keyword-based search and the power of semantic search.
Accessible through Azure AI Studio’s Cohere Rerank endpoint, our model computes a relevance score for a set of text documents compared to a given user query. This approach consistently yields superior search results, especially for complex and domain-specific queries, compared to traditional embedding-based semantic search.
Why Azure AI for Cohere Rerank models?
Cohere Rerank models are now available as serverless APIs through Models as a Service (MaaS), which is now Generally Available. This enables enterprise-scale workloads with ease.
Network Isolation for Inferencing: Protect your data from public network access.
Expanded Regional Availability: Access from multiple regions.
Data Privacy and Security: Robust measures to ensure data protection.
Quick Endpoint Provisioning: Set up a rerank endpoint in AI Studio in seconds.
Azure AI ensures seamless integration, enhanced security, and rapid deployment for your AI needs.
How to deploy Cohere Rerank 3 models on Azure AI studio?
Prerequisites:
If you don’t have an Azure subscription, get one here: https://azure.microsoft.com/en-us/pricing/purchase-options/pay-as-you-go
Familiarize yourself with Azure AI Model Catalog
Create an Azure AI Studio hub and project. Make sure you pick East US, West US3, South Central US, West US, North Central US, East US 2 or Sweden Central as the Azure region for the hub.
Create a deployment to obtain the inference API and key:
Open the model card in the model catalog on Azure AI Studio.
Click on Deploy and select the Pay-as-you-go option.
Subscribe to the Marketplace offer and deploy. You can also review the API pricing at this step.
You should land on the deployment page that shows you the API and key in less than a minute.
These steps are outlined in detail in the product documentation.
Please check some samples to get started – LangChain, Web Requests, Cohere Client
FAQ
What does it cost to use Cohere Rerank on Azure?
You are billed based on the number of prompt and completions tokens. You can review the pricing on the Cohere offer in the Azure Marketplace offer details tab when deploying the model. You can also find the pricing on the Azure Marketplace.
Are the Cohere models’ region specific on Azure?
Command R/R+/Embed/Rerank models are available as serverless API endpoints.
These endpoints can be created in Azure AI Studio projects or Azure Machine Learning workspaces. Cross-regional support for these endpoints is available in the following regions in the US: East US, East US 2 , West US3, South Central US, West US, North Central US, Sweden Central
Do I require GPU capacity quota in my Azure subscription to deploy Cohere Rerank models?
Cohere mdodels are available through MaaS as serverless API endpoints. You don’t require GPU capacity quota in your Azure subscription to deploy these models.
Cohere models are listed on the Azure Marketplace. Can I purchase and use these models directly from Azure Marketplace?
Azure Marketplace is our foundation for commercial transactions for models built on or built for Azure. The Azure Marketplace enables the purchasing and billing of Mistral models. However, model discoverability occurs in both Azure Marketplace and the Azure AI model catalog. Meaning you can search and find Cohere models in both the Azure Marketplace and Azure AI Model Catalog.
If you search for Cohere Rerank 3 in Azure Marketplace, you can subscribe to the offer before being redirected to the Azure AI Model Catalog in Azure AI Studio where you can complete subscribing and can deploy the model.
If you search for Cohere Rerank 3 in the Azure AI Model Catalog, you can subscribe and deploy the model from the Azure AI Model Catalog without starting from the Azure Marketplace. The Azure Marketplace still tracks the underlying commerce flow.
Given that Cohere models are billed through the Azure Marketplace, does it retire my Azure consumption commitment (aka MACC)?
Yes, Cohere models are “Azure benefit eligible” Marketplace offers, which indicates MACC eligibility. Learn more about MACC here: https://learn.microsoft.com/en-us/marketplace/azure-consumption-commitment-benefit
Is my inference data shared with Cohere?
No, Microsoft does not share the content of any inference request or response data with any model provider.
Microsoft acts as the data processor for prompts and outputs sent to and generated by a model deployed for pay-as-you-go inferencing (MaaS). Microsoft doesn’t share these prompts and outputs with the model provider, and Microsoft doesn’t use these prompts and outputs to train or improve Microsoft’s, the model providers, or any third party’s models. Read more on data, security and privacy for Models-as-a-Service.
Are there rate limits for the Cohere models on Azure?
Cohere models come with 400 K tokens per minute and 1 K requests per minute limit. Reach out to Azure customer support if this doesn’t suffice.
Can I use MaaS models in any Azure subscription types?
Customers can use MaaS models in all Azure subsection types with a valid payment method, except for the CSP (Cloud Solution Provider) program. Free or trial Azure subscriptions are not supported.
Microsoft Tech Community – Latest Blogs –Read More
New Microsoft Entra Suite
Get a unified solution for secure access management, identity verification, and Zero Trust security for cloud and on-premises resources. The new Microsoft Entra suite integrates five capabilities: Private Access, Internet Access, ID Protection, ID Governance, and Face Check in Verified ID Premium, included with Microsoft Entra Suite. With these, you can streamline user onboarding, enhance security with automated workflows, and protect against threats using Conditional Access policies. See how to reduce security gaps, block lateral attacks, and replace legacy VPNs, ensuring efficient and secure access to necessary resources.
Jarred Boone, Identity Security Senior Product Manager, shares how to experience advanced security and management with Microsoft Entra Suite.
Get a unified experience.
Secure access for any employee, from anywhere, to any app, AI, or resource. Get started with the Microsoft Entra Suite.
Streamline the onboarding process.
Verify users, prevent overprivileged permissions, improve detections, and enforce granular access controls for all users and resources. See the new Microsoft Entra Suite.
Establish policies to dynamically adjust.
Improve the hybrid workforce experience with seamless access to any resource. Check out the new Microsoft Entra Suite.
Check out our video here:
QUICK LINKS:
00:00 — Unified solution with Microsoft Entra Suite
00:38 — Microsoft Entra Private Access
01:39 — Microsoft Entra Internet Access
02:42 — Microsoft Entra ID Protection
03:31 — Microsoft Entra ID Governance
04:18 — Face Check in Verified ID Premium, included with Microsoft Entra Suite
04:52 — How core capabilities work with onboarding process
06:08 — Protect access to resources
07:22 — Control access to internet endpoints
08:05 — Establish policies to dynamically adjust
08:45 — Wrap up
Link References
Try it out at https://entra.microsoft.com
Watch our related deep dives at https://aka.ms/EntraSuitePlaylist
Check out https://aka.ms/EntraSuiteDocs
Unfamiliar with Microsoft Mechanics?
As Microsoft’s official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft.
Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries
Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog
Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/podcast
Keep getting this insider knowledge, join us on social:
Follow us on Twitter: https://twitter.com/MSFTMechanics
Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/
Enjoy us on Instagram: https://www.instagram.com/msftmechanics/
Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics
Video Transcript:
-The new Microsoft Entra Suite goes beyond what you may have today to advance secure access management, protect and verify any identity, and enforce a Zero Trust security approach for your cloud and on-premises resources. In fact, if you’re using multiple siloed tools to do this today, integration gaps can increase your security exposure.
-Whereas Microsoft Entra Suite provides a unified solution to strengthen your security posture, by providing you with five key capabilities. Private Access, Internet Access, ID Protection, ID Governance, and Face Check with Verified ID. These work with your existing processes, and I’ll first explain how each works, and demonstrate them in action. Starting with Microsoft Entra Private Access.
-This capability is designed to improve protections for on-premises apps and resources without any code changes. It works together with Conditional Access policies so that as resources are being accessed, Private Access uses identity, device, and application signals to assess risk in real-time. And it will then apply additional network conditions to increase access protections to any app resource, including file shares or on-premises servers.
-This identity-centric Zero Trust network access approach goes beyond which you can do today with traditional VPNs. In fact, it helps block lateral attack movement, reduces the risk of over-permissioning, and replaces legacy VPNs. And it works by using a locally installed global secure access agent on your user’s managed device.
-Then in your local network, you’ll install a private network connector as an agent to handle traffic, which only uses outbound connections. And these work together to securely establish the connection between the user and the private resource.
-Second, Microsoft Entra Internet Access is designed to prevent end user access to unsafe and non-compliant content. To keep your users and devices safe from internet threats, here we protect them against malicious traffic using cloud delivered network security controls. Including web content filtering, based off Microsoft maintained categories, as well as endpoints that you can define as an admin.
-And soon we’ll add threat intelligence filtering to also protect against continuously evolving known threats. This also provides fast and seamless access through a globally distributed secure network edge, and private WAN to optimize traffic routing to internet destinations.
-And importantly, it extends Conditional Access adaptive controls to internet security, where each access temp is assessed in real-time across identity, device, location, and risk signals to protect any internet destination. This way, you now have a single policy engine across cloud apps and internet endpoints. And both Internet Access, as well as Private Access, have a deep integration with ID Protection and ID Governance to automate what’s in scope, which we’ll cover next.
-In fact, our third capability, Microsoft Entra ID Protection, provides foundational risk-based Conditional Access and multi-factor authentication services for detecting and remediating identity risks. Machine learning is used to identify compromised or malicious user accounts, and automates action to mitigate these threats.
-Using Conditional Access adaptive controls, you can ensure users and devices meet predefined conditions prior to granting access to any resource. Conditional Access assesses sign-in risks to look for anomalous single events.
-And user risk assesses sign-in trends over time to determine if an account has potentially been compromised. And with token protection, tokens are bound to the issued device, which means if stolen, they cannot be replayed on another device. ID Protection also works with hybrid identities when you integrate it with your on-premises Active Directory Services.
-Then our fourth capability, Microsoft Entra ID Governance, lets you balance security and productivity by ensuring that the right people have the right access to the right resources for the right amount of time. For example, for everyday users, you can ensure just enough access is granted so that users can only access what they need, and nothing more, to get their jobs done.
-Also, identity lifecycle management in Microsoft Entra lets you use workflow automation for provisioning your managed apps, data, and services, even those on premise. And you can couple that with additional steps, like procurement of computer hardware and more. And this is done together with entitlement management to select just the right resources and apps to prevent over-permissioning.
-Equally, the same lifecycle automation lets you grant access to people as they change roles, or remove access as employees leave your organization. Which brings us to our fifth capability, Face Check with Verified ID.
-This works together with ID Protection and ID Governance controls to accelerate and protect user onboarding. It’s a part of the Verified ID platform in Microsoft Entra. As a decentralized identity solution, it lets users verify credentials together with those from third party issuers, and prove they are who they say they are, without manual checks.
-Along with your government issued ID, face check with the Authenticator app can use the local device camera as a live motion image feed to ensure the person presenting that verified ID is in fact who they claim to be. So now that I’ve explained the five core capabilities of Microsoft Entra Suite, let me demonstrate them working together in action across everyday connected scenarios.
-Let’s start with the user onboarding process after the initial setup. In this example, our user account is only provisioned in our HR app, Workday. If we look at the user profile in Microsoft Entra, we can see all the attributes were automatically mapped from Workday, including the user’s hire date.
-The problem is that even though the account is in the directory service, the user does not yet have access to all resources needed to do their job. And this is where you can use lifecycle workflows as a part of ID Governance. Based on user attributes, like their department and location, I’ve created a simple automated workflow here.
-First, it will send a welcome email. Then the next task automatically assigns the user to the right group with the right software licenses, access to required on-premise and cloud-based apps, permission to sites in SharePoint. And even controls to govern access to internet endpoints.
-Finally, this custom task extension works with our ticketing system to procure the required computer hardware for this role. Workflows like these automatically detect accounts with matching conditions to automate defined tasks, saving you and your users time while right sizing and securing access to both cloud-based and on-premises apps and resources.
-In fact, with accounts onboarded and access to resources assigned, let’s move on to how Microsoft Entra Suite protects access to resources, first on your private network. Here, I’m shown an enrolled device with Global Secure Access client installed. I’ll paste the legacy on-premises hosted app address into my browser.
-And as you might expect, I can reach the site seamlessly, because this is a trusted device, I’m a trusted user, and I’m in a trusted sign in location on a trusted internal wifi network. This time, I’ll show you how this works on the same device, except using a different wifi network. I’ll change my connection in settings to Fourth Coffee Free Wifi, then move back to the browser.
-When I paste in the URL for the app we saw before, Conditional Access recognizes the changes of network location, and determines that there is additional risk with an untrusted network, asking me to re-authenticate. In this case, the policy is configured to allow me to prove my identity using passwordless authentication.
-Then I get access to the private app. Then beyond internally hosted apps, this also works for accessing other on-premise resources, like domain joined virtual machines running on local servers, or accessing on-premise file shares protected using Kerberos authentication.
-And both of these even work from non domain joined devices, and without a VPN. Additionally, Microsoft Entra Internet Access combines multiple Microsoft Entra Suite capabilities as you control access to internet endpoints.
-As an admin, you can create web content filtering policies for web categories and FQDNs. For example, you can block social networking like X, but allow professional networking sites like LinkedIn. This works with your Conditional Access policies as you scope users or groups, and optionally define exclusions.
-Importantly, these policies also work hand in hand with ID Governance, so that you can automate who is added or removed from policy scope as they enter, move within, or leave the organization. So as a user scope for this policy, access to X in our case will be blocked, but if they go to LinkedIn, you’ll see that it’s allowed.
-Additionally, you can establish policies that dynamically adjust based on changing risk levels, which is a lot smarter than firewall rules that you may have traditionally set. In the Conditional Access policy, an identity flag with high user risk usually indicates that the account has been compromised.
-Over time, they may have performed multiple risk activities, such as suspicious API calls or sending patterns. If you pair this condition with web filtering controls, like limiting access to web repository and storage sites, once an identity and scope for the policy is flagged with high user risk, you can block the user account from accessing those sites.
-And access will automatically get restored when the user risk signal changes and drops below a certain level. So that’s how Microsoft Entra Suite goes beyond what you may have today to unify and advance secure access management, protect and verify any identity, and enforce a Zero Trust security approach for your cloud and on-premises resources.
-Try it out today at entra.microsoft.com, and watch our related deep dives at ak.ms/EntraSuitePlaylist. Also, to learn more, check out ak.ms/EntraSuiteDocs. Subscribe to Microsoft Mechanics for the latest tech updates, and thanks for watching.
Microsoft Tech Community – Latest Blogs –Read More
Get AI ready: Build skills with Microsoft Learn
As AI transforms the way we work, business leaders around the world are exploring ways to implement AI solutions. And technology professionals are looking to quickly build their AI skills to benefit their careers, projects, and teams.
At the same time, organizations are confronting a skills gap. In fact, according to the 2024 Work Trend Index Annual Report from Microsoft and LinkedIn, 55% of leaders report that they’re concerned about having enough talent to fill roles in the year ahead and 76% of professionals say that they need AI skills to remain competitive. The good news is that Microsoft Learn offers skill-building resources, opportunities, and solutions to meet these critical needs.
To accelerate AI transformation, we recommend a skills-first approach—emphasizing skills and competencies, in addition to degrees and job histories. We suggest focusing on skill building for your whole organization:
Take a structured approach. Begin with basic AI concepts as technical teams build the skills to onboard Microsoft Copilot experiences and create AI apps. Help business users understand how to use AI in their work, and help ensure that those in technical roles have the skills to design, build, and deploy solutions to address your organization’s unique business scenarios.
Upskill across every role. Beyond IT, everyone in your organization plays a key role in company-wide AI adoption. To help develop, deploy, and make the best use of new AI solutions, upskill your entire workforce.
Work with a trusted partner. Start with the AI learning hub on Microsoft Learn, which offers training to accelerate your AI transformation. With Microsoft Learn, business leaders can get the skills to craft strategic AI plans, technical teams can learn to create and implement AI applications with Microsoft AI solutions, and business users can make the most of new AI skills to supercharge their productivity.
Discover the latest industry insights around AI skills in our recently published position paper Accelerate AI transformation with skill building, which highlights the experiences of customers and partners who are running AI skill-building initiatives. Offering practical guidance, it expands on key ways that you can drive successful AI transformation in your organization.
Learn Microsoft AI with our new blog series
Today, we’re launching “Get AI ready,” our new AI-focused series of blog posts exploring perspectives and opportunities to acquire critical AI skills. In this series, we share insights, learning experiences, resources, and ideas for individuals and organizations as we all navigate the world of AI skill building.
Plus, we share how we’re refreshing our training offerings—and how we’re using AI to improve them—so you know that you can learn the latest skills in the most productive way. We understand the challenges, uncertainties, and benefits that come with AI, and we’re creating this series to help you find what you need to skill up for success.
Wondering what to expect? Here’s a sneak peek into future posts:
Deep dives into AI learning journey resources from Microsoft Learn
Real-world AI skill-building success stories and best practices from individuals and organizations
Microsoft as customer zero for AI adoption and what we’ve learned about skilling up our own employees
How to foster a culture of AI learning and innovation
How to prove your AI skills with Microsoft Credentials
No matter where you are on your AI learning journey, Microsoft Learn meets you there with the resources you need to build and validate your skills—and we’re there for individuals, teams, and organizations alike.
Coming next: Get AI ready: Build technical skills with the Copilot learning hub
Stay tuned for our next post! We’ll explore the new Copilot learning hub on Microsoft Learn, created for technology professionals and filled with helpful resources tailored to specific job roles and career goals. It’s where you can find what you need to develop the technical skills to put Microsoft Copilot to work for you. In the post, we’ll include insider information from the team that creates these resources. Spoiler alert: Expect tips and tricks on how to choose your perfect Copilot experience and make the most of it to help boost your efficiency and productivity.
From initial AI skill building across every role, to making the most of Copilot at your desk each day—and beyond—we look forward to sharing this AI learning journey with you as we help close the skills gap together.
Follow us on X and LinkedIn, and make sure you’re subscribed to The Spark, our LinkedIn newsletter.
Microsoft Tech Community – Latest Blogs –Read More
Create a custom field in the new Microsoft Planner
When executing on a plan, tracking various aspects like task status or risks is crucial for managing progress. With the new Planner, you can create custom fields helping teams stay on top of what matters most for their initiatives, making it easier and faster to identify and assess where things are on track and what needs follow up.
Creating a custom field
1. Once you create your premium Plan, go to the Grid view, select Add column > New field.
2. Choose an appropriate field Type:
3. Enter a Field name, then select Create.
Note: You can create up to 10 custom fields in a premium plan.
Choose a type for custom field
There are several types of custom fields available, each serving a different purpose:
Text: Can contain any characters. Use it to add columns for justifications, notes, or descriptions.
Date: Can contain any date. You can type it in yourself or select from a calendar. Use it to track important dates, such as approval dates.
Number: Can only contain numbers. You can optionally “rollup” values in subtasks with Max, Min, Sum, and Average calculations. When you create the number field, choose your Rollup type. Try it by creating a number column called “Estimate” and use a Sum calculation for it. Use this column to estimate the amount of work it will take to complete the task.
Yes/No: This field offers a drop-down list with “Yes” and “No” options, which can be used to track quality or process checks.
Choice: Create a drop-down list with 2 to 20 options, including characters and emojis. For example, you can add a “Risk” field with a few choices such as “High”, “Medium” and “Low”.
To add emojis, on Windows press Win + ; (Windows key plus semicolon) and on Mac, press Control + Command + Space.
You can add colors to each choice to make it easier to review the state of work in the grid view. You can do so by selecting the paint bucket icon or you can remove the colors by selecting the trash can icon.
Copy or Edit the custom fields
You can copy an existing plan as a template to leverage its structure for a new project. This process also copies all custom fields, allowing you to easily reuse your previous setup.
You can easily edit any custom field you add by selecting ‘Edit’ from the custom column menu in the Grid view. You can also add custom coloring or filtering based on the content in the custom fields.
Ready to start using it all?
If you currently use Microsoft 365 and Microsoft Teams, explore the new Planner app in Teams, and try the premium capabilities from within the Planner app by simply clicking on the diamond icon within the app where you can begin your free 30-day trial of these advanced capabilities or proceed with requesting a premium license. If you already have a Project license you’re already equipped with access to the new Planner’s premium capabilities corresponding to the license you have.
Share your feedback
You can share feedback through the new Planner app in Teams directly. You can also send us your feedback via the Planner Feedback Portal.
Here is how you can share your feedback directly from within the new Planner app.
Learn more about the new Planner
• Explore the new Day in the Life guides to use Planner and Copilot for individual task management, collaborative work management and project management.
• Watch the new Planner demos for inspiration on how to get the most out of the new Planner app in Microsoft Teams.
• Bookmark the new Planner adoption website.
• We’ve got a lot more ‘planned’ for the new Planner this year! Stay tuned to the Planner Blog – Microsoft Community Hub for news.
• For Planner feature updates, visit the Microsoft 365 roadmap here
• Learn about Planner and Project plans and pricing here
• Read the FAQs here
Microsoft Tech Community – Latest Blogs –Read More
Autopilot Resett and MFA for Device Registration
MFA is enforced over CA-Policy for Device Registration.
When we apply an autopilot-resett via Intune admin center, the assigned user must login again and perform MFA after autopilot Provisioning. Otherwise the userbased apps and policies are not assigned and the device is not full enrolled. Is there a solution to perform mfa during esp in autopilot?
MFA is enforced over CA-Policy for Device Registration.When we apply an autopilot-resett via Intune admin center, the assigned user must login again and perform MFA after autopilot Provisioning. Otherwise the userbased apps and policies are not assigned and the device is not full enrolled. Is there a solution to perform mfa during esp in autopilot? Read More
Bad Request – Request Too Long HTTP Error 400. The size of the request headers is too long.
I am moving a web site from Windows Server 2012 to Windows Server 2022. When I open my web site, I receive the error message: Bad Request – Request Too Long HTTP Error 400. The size of the request headers is too long.
When I inspected the headers, they were only 640 characters long. I have cleared my cache and flushed DNS to no avail.
This error doesn’t happen all the time, just sporadically. How do I fix this so that it doesn’t happen.
I am moving a web site from Windows Server 2012 to Windows Server 2022. When I open my web site, I receive the error message: Bad Request – Request Too Long HTTP Error 400. The size of the request headers is too long. When I inspected the headers, they were only 640 characters long. I have cleared my cache and flushed DNS to no avail. This error doesn’t happen all the time, just sporadically. How do I fix this so that it doesn’t happen. Read More
Azure DevOps REST API – retrieve DevOps Server/TFS version
Hi all,
I need to support multiple Azure DevOps Server/TFS instances. Is there a REST API to retrieve the version + other “system” info of a given instance?
The ideal would be something like /status/health API (only available for DevOps Services), not even requiring authentication.
Is there something similar?
Thanks in advance!
Hi all,I need to support multiple Azure DevOps Server/TFS instances. Is there a REST API to retrieve the version + other “system” info of a given instance? The ideal would be something like /status/health API (only available for DevOps Services), not even requiring authentication.Is there something similar? Thanks in advance! Read More
Teams personal app – There was a problem reaching this app
The bug occurs when the personal app requests video permission and the user reloads the app during this process. The reload loads the app, but the video permission request throws an error: “DOMException: Failed due to shutdown”. This error indicates that the next reload will cause the app to break.
Once this bug occurs, all personal apps fail to load, displaying the error message: “There was a problem reaching this app.” The only ways to open the app without encountering this bug are to open it in a new window or restart Microsoft Teams.
System Information:
• OS: macOS Sonoma 14.3
• CPU: Apple M1 Pro
• Microsoft Teams version: 24180.207.2997.1350
• Teams client version: 50/24062724814
Additional Notes:
The bug does not seem to occur on Windows, suggesting it may be specific to the macOS version of Microsoft Teams.The page that the personal app opens requests camera permission everytime that the page loads
Steps to Replicate:
1.Open the personal app.
2.Reload the app when the camera icon appears in the macOS menu bar.
3.Observe that the app loads but encounters an error when trying to get permissions: DOMException: Failed due to shutdown (indicating the next reload will fail).
4.Reload the app again.
5.The bug should now be replicated.
When the bug occurs, the screen display this page, if you have a loading indicator, else displays a blank page.
Bug – There was a problem reaching this app
I don’t know if this is the better place to create this bug, if not, please redirect me for the correct place. Thank you!
The bug occurs when the personal app requests video permission and the user reloads the app during this process. The reload loads the app, but the video permission request throws an error: “DOMException: Failed due to shutdown”. This error indicates that the next reload will cause the app to break. Once this bug occurs, all personal apps fail to load, displaying the error message: “There was a problem reaching this app.” The only ways to open the app without encountering this bug are to open it in a new window or restart Microsoft Teams. System Information:• OS: macOS Sonoma 14.3• CPU: Apple M1 Pro• Microsoft Teams version: 24180.207.2997.1350• Teams client version: 50/24062724814 Additional Notes: The bug does not seem to occur on Windows, suggesting it may be specific to the macOS version of Microsoft Teams.The page that the personal app opens requests camera permission everytime that the page loads Steps to Replicate: 1.Open the personal app.2.Reload the app when the camera icon appears in the macOS menu bar.3.Observe that the app loads but encounters an error when trying to get permissions: DOMException: Failed due to shutdown (indicating the next reload will fail).4.Reload the app again.5.The bug should now be replicated. When the bug occurs, the screen display this page, if you have a loading indicator, else displays a blank page. Bug – There was a problem reaching this appI don’t know if this is the better place to create this bug, if not, please redirect me for the correct place. Thank you! Read More
Admin accounts which do not have the flag “This account is sensitive and cannot be delegated”
Hi AD Brain trust,
I’m currently working on a security assessment for our internal AD environment. One of the item in the report is – Presence of Admin accounts which do not have the flag “This account is sensitive and cannot be delegated”: 6
I’m struggling to understand the consequences of setting the flag for admin accounts. If anyone can shed some lights on the implications/recommendations to resolve this detection would be greatly appreciated !
Thank you!
Hi AD Brain trust, I’m currently working on a security assessment for our internal AD environment. One of the item in the report is – Presence of Admin accounts which do not have the flag “This account is sensitive and cannot be delegated”: 6 I’m struggling to understand the consequences of setting the flag for admin accounts. If anyone can shed some lights on the implications/recommendations to resolve this detection would be greatly appreciated ! Thank you! Read More
System.InvalidCastException: The COM object of the type “Outlook.ApplicationClass” cannot be convert
Hello everyone,
We have an Outlook addon that communicates with our application. Our application used to be 32 bit. However, we changed it to 64 bit.
We use the Microsoft.Office.Interop.Outlook DLL to create emails, appointments and so on.
Recently we have been having problems with creating objects and unfortunately we do not know what exactly the problem is.
We always get an exception like this:
System.InvalidCastException: Das COM-Objekt des Typs “Outlook.ApplicationClass” kann nicht in den Schnittstellentyp “Outlook._Application” umgewandelt werden.
Dieser Vorgang konnte nicht durchgeführt werden, da der QueryInterface-Aufruf an die COM-Komponente für die Schnittstelle mit der IID “{00063001-0000-0000-C000-000000000046}” aufgrund des folgenden Fehlers nicht durchgeführt werden konnte:
Element nicht gefunden. (Ausnahme von HRESULT: 0x8002802B (TYPE_E_ELEMENTNOTFOUND)).
bei System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
bei Outlook.ApplicationClass.GetNamespace(String Type)
or
System.InvalidCastException: Das COM-Objekt des Typs “Microsoft.Office.Interop.Outlook.ApplicationClass” kann nicht in den Schnittstellentyp “Microsoft.Office.Interop.Outlook._Application”
umgewandelt werden. Dieser Vorgang konnte nicht durchgeführt werden, da der QueryInterface-Aufruf an die COM-Komponente für die Schnittstelle mit der
IID “{00063001-0000-0000-C000-000000000046}” aufgrund des folgenden Fehlers nicht durchgeführt werden konnte: Fehler beim Laden der Typbibliothek/DLL.
(Ausnahme von HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).
bei System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)
bei Microsoft.Office.Interop.Outlook.ApplicationClass.get_Session()
The only solutions we found online were to repair Office, which we and our customers did. Unfortunately, it only works for a few days or weeks and then the problem reappears.
We tried to reproduce the problem with a powershell script and we could. This is the script:
$Outlook = New-Object -ComObject Outlook.Application
$Mail = $Outlook.CreateItem(0) # 0 steht für MailItem
$Mail.Subject = “Test E-Mail von PowerShell”
$Mail.Body = “Dies ist eine Test-E-Mail, die mit PowerShell erstellt wurde.”
$Mail.Display()
Write-Host “Das E-Mail-Fenster wurde angezeigt.”
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($Mail) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($Outlook) | Out-Null
What is the problem? Could the problem be related to Windows group policies? If so, which ones?
We have a lot of customers that have this problem so we need help asp.
Thanks and best regards
Hello everyone, We have an Outlook addon that communicates with our application. Our application used to be 32 bit. However, we changed it to 64 bit.We use the Microsoft.Office.Interop.Outlook DLL to create emails, appointments and so on.Recently we have been having problems with creating objects and unfortunately we do not know what exactly the problem is.We always get an exception like this:System.InvalidCastException: Das COM-Objekt des Typs “Outlook.ApplicationClass” kann nicht in den Schnittstellentyp “Outlook._Application” umgewandelt werden.Dieser Vorgang konnte nicht durchgeführt werden, da der QueryInterface-Aufruf an die COM-Komponente für die Schnittstelle mit der IID “{00063001-0000-0000-C000-000000000046}” aufgrund des folgenden Fehlers nicht durchgeführt werden konnte:Element nicht gefunden. (Ausnahme von HRESULT: 0x8002802B (TYPE_E_ELEMENTNOTFOUND)).bei System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)bei Outlook.ApplicationClass.GetNamespace(String Type)or System.InvalidCastException: Das COM-Objekt des Typs “Microsoft.Office.Interop.Outlook.ApplicationClass” kann nicht in den Schnittstellentyp “Microsoft.Office.Interop.Outlook._Application”umgewandelt werden. Dieser Vorgang konnte nicht durchgeführt werden, da der QueryInterface-Aufruf an die COM-Komponente für die Schnittstelle mit derIID “{00063001-0000-0000-C000-000000000046}” aufgrund des folgenden Fehlers nicht durchgeführt werden konnte: Fehler beim Laden der Typbibliothek/DLL.(Ausnahme von HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)).bei System.StubHelpers.StubHelpers.GetCOMIPFromRCW(Object objSrc, IntPtr pCPCMD, IntPtr& ppTarget, Boolean& pfNeedsRelease)bei Microsoft.Office.Interop.Outlook.ApplicationClass.get_Session() The only solutions we found online were to repair Office, which we and our customers did. Unfortunately, it only works for a few days or weeks and then the problem reappears. We tried to reproduce the problem with a powershell script and we could. This is the script:$Outlook = New-Object -ComObject Outlook.Application$Mail = $Outlook.CreateItem(0) # 0 steht für MailItem$Mail.Subject = “Test E-Mail von PowerShell”$Mail.Body = “Dies ist eine Test-E-Mail, die mit PowerShell erstellt wurde.”$Mail.Display()Write-Host “Das E-Mail-Fenster wurde angezeigt.”[System.Runtime.Interopservices.Marshal]::ReleaseComObject($Mail) | Out-Null[System.Runtime.Interopservices.Marshal]::ReleaseComObject($Outlook) | Out-Null What is the problem? Could the problem be related to Windows group policies? If so, which ones? We have a lot of customers that have this problem so we need help asp. Thanks and best regards Read More
64-bit Excel Power Pivot stuck on “reading data” for a small one-to-many relationship
Hi,
Can anyone please tell me why the Excel Power Pivot for this simple one-to-many data model never finishes “Reading data…”?
Masters has 6000 rows
Sub Accounts has 63,000 rows
The same model works as expected in Power BI desktop!
Hi, Can anyone please tell me why the Excel Power Pivot for this simple one-to-many data model never finishes “Reading data…”? Masters has 6000 rowsSub Accounts has 63,000 rows The same model works as expected in Power BI desktop! Read More
How to Send a High Importance email through PowerShell Script
I am login through exchange server ‘Web Outlook App’ to send email out. The send email is working fine, but I want to know how to send a ‘Priority’ email. I’ve tried everything and the email send is not sending as ‘Priority’. Please let me know the syntax for Power Shell script. These are the one that try so far and none of them are working.
I am login through exchange server ‘Web Outlook App’ to send email out. The send email is working fine, but I want to know how to send a ‘Priority’ email. I’ve tried everything and the email send is not sending as ‘Priority’. Please let me know the syntax for Power Shell script. These are the one that try so far and none of them are working. # Send High Performance Email#[System.Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12#$emailPriority = [System.Net.Mail.MailPriority]::High#$emailPriority = “2”#$email.Priority = [System.Net.Mail.MailPriority]::High#$emailHighPriority =”High”#$emailMessage.Priority = [System.Net.Mail.MailPriority]::High#$mailMessage.Priority = [System.Net.Mail.MailPriority]::High#`$emailMessage.Priority = [System.Net.Mail.MailPriority]::High`#$emailMessage = New-Object System.Net.Mail.MailMessage#$emailMessage.Priority = 2#$email = New-Object System.Net.Mail.MailMessage#$email.Priority = [System.Net.Mail.MailPriority]::High Read More
Microsoft Remote Desktop crashes when trying to connect to virtual desktop
I have one person who is trying to connect to an azure virtual machine via MSRD. When she clicks on the remote icon nothing happens. I went into event viewer and found this.
Faulting application name: msrdc.exe, version 1.2.5559.0, time stamp: 0x669718bf
Faulting module name: ntdll.dll, version: 10.0.19041.4522, time stamp: 0x8a1bb6f3
Exception code 0xc0000409
Fault Offset: 0x00000000000a1a91
Faulting process id: 0x4990
Faulting application path C:Program FilesRemote Desktopmsrdc.exe
Faulting module path: C:WindowsSYSTEM32ntdll.dll
This is on a Windows 10 machine. I have tried uninstalling and reinstalling MSRDT, I tried using a different profile on the same computer. With no luck. I tried older versions of MSRDT as well. I already tried chkdsk and scannow. Any ideas would be great!
I have one person who is trying to connect to an azure virtual machine via MSRD. When she clicks on the remote icon nothing happens. I went into event viewer and found this. Faulting application name: msrdc.exe, version 1.2.5559.0, time stamp: 0x669718bfFaulting module name: ntdll.dll, version: 10.0.19041.4522, time stamp: 0x8a1bb6f3Exception code 0xc0000409Fault Offset: 0x00000000000a1a91Faulting process id: 0x4990Faulting application path C:Program FilesRemote Desktopmsrdc.exeFaulting module path: C:WindowsSYSTEM32ntdll.dll This is on a Windows 10 machine. I have tried uninstalling and reinstalling MSRDT, I tried using a different profile on the same computer. With no luck. I tried older versions of MSRDT as well. I already tried chkdsk and scannow. Any ideas would be great! Read More
M365 Developers Update | July 2024 Edition
In this monthly blog series focused on M365, we will be sharing product updates, notable reads, and other new resources that can be leveraged by developers who are building apps for the commercial marketplace.
Spotlight
Discover how extensibility for Copilot for Microsoft 365 works. Read More.
Copilot extensions: Learn how to extend, customize, and amplify Copilot capabilities. Get started.
Build your own highly specialized copilot using Microsoft Copilot Studio or Visual Studio Code Learn how.
See how you can build your custom copilot for Teams with the Teams AI library Watch now.
Build Copilot extensions with our samples collection. Go now.
Learn
Learn how Dev Proxy can help you achieve more with APIs in your organization. Try it now.
Discover how you can build AI-powered apps that run on Microsoft Teams with help from Azure Communication Services. Watch the tutorial.
Develop your Office add-ins with a collection of prompt examples to use with GitHub Copilot. Start now.
Explore the latest Teams Toolkit for Visual Studio Code updates to discover a faster way to debug your Teams apps. Get the updates.
Online Training
See what you missed at Microsoft Build 2024 Watch all breakout sessions on demand. Catch up now.
Collection of free Microsoft Copilot prompts Transform your workflow with a new community-led repository set. Learn more.
Copilot extensibility learning module Get started with Microsoft Copilot for Microsoft 365 extensibility. Begin today.
Community calls Learn from our experts on a variety of Microsoft 365 platform topics. Join a call.
Microsoft Tech Community – Latest Blogs –Read More
What’s new in Viva Connections mid-year update
We’re excited to announce a range of new capabilities for Viva Connections designed to bring your Viva Connections experiences into the flow of work, add customization to the Spotlight feature, understand how users are engaging with the app and bring new integrations into dashboard cards. Here’s what’s new:
New ways to stay connected
Viva Connections is all about connecting you to the things you need, and now, you can get Desktop Notifications to ensure you don’t miss the latest news and announcements. And updated notification settings and performance improvements give you additional control on what you see, faster loading, tablet personalization, and helpful tools like inline authoring.
To better connect your employees to the resources they need most, we’ve recently rolled out the ability to import global navigation items into the Viva Connections Resources tab.
We’ve also released Viva Connections on the web that brings a dynamic, beautiful app experience directly into the browser.
Communicating through the employee app
The new customizable Spotlight offers communicators a sleek, above-the-fold section to highlight key news. Up to eleven pieces of news can be added to the Spotlight carousel for announcements and campaigns that need extra emphasis and durability.
Highlight key news and campaigns with Spotlight
New communication features also enable Regional Announcements, which provides additional attribute-based targeting based on job, title, and location. This is specifically geared for reaching Frontline Workers (FLWs) working in different regions, branches, stores, or departments by using filtering.
Learn more about how to set up regional filtering and using FLW announcements. Note this feature requires Frontline licensing.
Analytics
Admins can now understand how and when users engage with components of the Viva Connections experience. You can see data on overall traffic, usage, and engagement across each of your organization’s Connections experiences. Learn more about how to access usage data here.
Cards
Dashboard cards in Viva Connections are the building blocks to a modern employee experience. A few months ago, we previewed a few cards for frontline workers which are now available.
Pulse Card – The Viva Pulse card in Viva Connections allows you to create Pulse survey (s) via the dashboard, giving employees a quick and targeted way to share feedback and participate in workplace surveys. Once the survey is complete, the owner can view the response rate right on the card.
Assigned Tasks Card
The Assigned Tasks card automatically displays information to users about their assigned tasks to. This information is retrieved from the Tasks app in Teams and enables users to quickly take action and accomplish tasks right from their dashboard.
OneDrive Card update
This new card allows organizations to add a OneDrive Files Card to the Viva Connections dashboard, showing recently accessed, shared, or favorite files. This card is now generally available and requires no action for setup.
Learn more about our Viva Connections dashboard cards in this blog.
We’re excited about the future of Viva Connections as more and more enterprises and frontline workers have built this app into their daily and weekly habits. We’ll have more updates to share soon — stay tuned!
Microsoft Tech Community – Latest Blogs –Read More
Announcing public preview of new Mbv3 Virtual Machines
As we launched memory-optimized Mv3 Medium Memory in Nov ’23, the demand for further storage optimization has been high. Today, we are excited to announce that the new Mbv3 series (Mbsv3 and Mbdsv3), featuring both storage-optimized and memory-optimized, are now available in public preview.
Key features on the new Mbv3 VMs
The memory-optimized and storage-optimized Mbv3 VM (Mbsv3 and Mbdsv3) series are based on the 4th generation Intel® Xeon® Scalable processors, scale for workloads up to 4TB, and deliver higher remote disk storage performance
These new VM sizes offer up to 650,000 IOPS, providing a 5x improvement in network throughput over the previous M-series families.
These new VM sizes also offer up to 10GBps of remote disk storage bandwidth, providing a 2.5x improvement in remote storage bandwidth over the previous M-series families.
The increased remote storage performance of these VMs is ideal for storage throughput-intensive workloads such as relational databases and data analytics applications.
Designed from the ground up for increased resilience against failures in memory, disks, and networking based on intelligence from past generations.
Available in both disk and diskless offerings, allowing customers the flexibility to choose the option that best meets their workload needs.
Mbsv3 series
Size
vCPU
Memory: GiB
Max data disks
Max uncached Premium SSD throughput: IOPS/MBps
Max uncached Ultra Disk and Premium SSD V2 disk throughput: IOPS/MBps
Max NICs
Max network bandwidth (Mbps)
Standard_M16bs_v3
16
128
64
44,000/1,000
64,000/1,000
8
8,000
Standard_M32bs_v3
32
256
64
88,000/2,000
88,000/2,000
8
16,000
Standard_M48bs_v3
48
384
64
88,000/2,000
120,000/2,000
8
16,000
Standard_M64bs_v3
64
512
64
88,000/2, 000
160,000/2, 000
8
16,000
Standard_M96bs_v3
96
768
64
260,000/4,000
260,000/4,000
8
25,000
Standard_M128bs_v3
128
1024
64
260,000/4,000
400,000/4,000
8
40,000
Standard_M176bs_v3
176
1536
64
260,000/6,000
650,000/6,000
8
50,000
Standard_M176bs_3_v3
176
2796
64
260,000/8,000
650,000/10,000
8
40,000
Mbdsv3 series
Size
vCPU
Memory: GiB
Temp storage (SSD) GiB
Max data disks
Max temp storage throughput: IOPS/MBps*
Max uncached Premium SSD throughput: IOPS/MBps
Max uncached Ultra Disk and Premium SSD V2 disk throughput: IOPS/MBps
Max NICs
Max network bandwidth (Mbps)
Standard_M16bds_v3
16
128
400
64
10,000/100
44,000/1,000
64,000/1,000
8
8,000
Standard_M32bds_v3
32
256
400
64
20,000/200
88,000/2,000
88,000/2,000
8
16,000
Standard_M48bds_v3
48
384
400
64
40,000/400
88,000/2,000
120,000/2,000
8
16,000
Standard_M64bds_v3
64
512
400
64
40,000/400
88,000/2,000
160,000/2,000
8
16,000
Standard_M96bds_v3
96
768
400
64
40,000/400
260,000/4,000
260,000/4,000
8
25,000
Standard_M128bds_v3
128
1,024
400
64
160,000/1600
260,000/4,000
400,000/4,000
8
40,000
Standard_M176bds_v3
176
1,536
400
64
160,000/1600
260,000/6,000
650,000/6,000
8
50,000
Standard_M176bds_3_v3
176
2796
400
64
160,000/1600
260,000/8,000
650,000/10,000
8
40,000
Standard_M64bds_1_v3
64
1397
3000
64
40,000/400
130,000/6,000
160, 000/6,000
8
20,000
Standard_M96bds_2_v3
96
1946
4500
64
40,000/400
130,000/8,000
260,000/8,000
8
20,000
Standard_M128bds_3_v3
128
2794
6000
64
160,000/1600
260,000/8,000
400,000/10,000
8
40,000
Standard_M176bds_4_v3
176
3892
8000
64
160,000/1600
260,000/8,000
650,000/10,000
8
40,000
Regional Availability
The preview is available in West Europe, North Europe, and East US, South Central US .
Join the Preview
You can try out the preview by filling out this form.
Microsoft Tech Community – Latest Blogs –Read More
how can i complaint on cred
क्रेड की ग्राहक सेवा टीम या तो फोन, 096648-47919. ईमेल, या उनकी वेबसाइट के ग्राहक सहायता पोर्टल के माध्यम से। 080164–56551., लिखित शिकायत दर्ज करें: अपनी मौखिक शिकायत के बाद लिखित शिकायत दर्ज करें।
क्रेड की ग्राहक सेवा टीम या तो फोन, 096648-47919. ईमेल, या उनकी वेबसाइट के ग्राहक सहायता पोर्टल के माध्यम से। 080164–56551., लिखित शिकायत दर्ज करें: अपनी मौखिक शिकायत के बाद लिखित शिकायत दर्ज करें। Read More
ISBLANK used with TODAY() but text in cell gives a #VALUE! error
Hi there, I have formula to give a blank if there is not an entry in the cell I am calculating the date on, but my added secondary level is that if the cell contains text rather than a date in it, then it returns #VALUE!
So I have =IF(ISBLANK(E5),” “,E5-TODAY()) which gives a result of 37 – as in number of days left as E5 contains a date 37 days from today
But then I have =IF(ISBLANK(F5),” “,F5-TODAY()) which gives a result of #VALUE! and this is because cell F5 contains text
I assume it needs to be something like either AND OR ISERROR ISNUMBER combined with the IF ISBLANK above, but my brain cannot compute what it needs and neither can searching for an answer as I probably am not asking for the correct thing!
Thanks in advance
Hi there, I have formula to give a blank if there is not an entry in the cell I am calculating the date on, but my added secondary level is that if the cell contains text rather than a date in it, then it returns #VALUE! So I have =IF(ISBLANK(E5),” “,E5-TODAY()) which gives a result of 37 – as in number of days left as E5 contains a date 37 days from today But then I have =IF(ISBLANK(F5),” “,F5-TODAY()) which gives a result of #VALUE! and this is because cell F5 contains text I assume it needs to be something like either AND OR ISERROR ISNUMBER combined with the IF ISBLANK above, but my brain cannot compute what it needs and neither can searching for an answer as I probably am not asking for the correct thing! Thanks in advance Read More