microsoft lists
1605 TopicsIntroducing Drag and Drop to Reorder Items in Microsoft Lists
You asked, and we listened! We’re excited to announce the arrival of a long-awaited feature in Microsoft Lists: drag and drop to reorder List items! This new feature will allow you to effortlessly rearrange your list items, making organization more efficient for all your busy lists.12KViews5likes35CommentsSharePoint List Titles not showing
Hi all! I'm having an issue where when I am creating new items in my list, the title section is not showing. It is not even an option for me to check when I try to edit the form itself. I have confirmed that the title column is mandatory however it still isn't show.132Views3likes6CommentsMultiple descriptions on List Calendar View
I was wondering if it is possible to have multiple descriptions on a List item in the Calendar view. Right now I have a travel form and it shows the name of the person going on leave but i would also like to **bleep** their destination to the line if possible. Thanks for the help in advance!107Views0likes3CommentsSharePoint List Rule to send email not allowing shared mailbox email address
Hi I have tried to search for an answer to this to no avail. We have a SharePoint list and want to create a rule that sends an email when a new list item is created. Sounds simple but I can't seem to add a SharedMailbox email address only UserMailbox email addresses. We do have a work around where we have created a rule in outlook instead that when the email arrives to the UserMailbox forward it to the correct SharedMailbox but it seems a bit silly that I can't directly add a SharedMailbox to the SharePoint list directly from the below. See below the screenshot of where I am trying to insert the SharedMailbox email address. It doesn't find it and if I add it in manually the create rule button doesn't activate. Am I missing something? Thank you!122Views0likes3CommentsCollect information like a pro – New Microsoft Lists forms experience
The new forms experience in Microsoft Lists is now rolling out for Microsoft 365 work and school. Our goal is to make it easier to collect and gather information directly into your lists – saving you time and effort. Thus, we are excited to launch a new forms experience built right inside Microsoft Lists – rolling out now. Note: This relates to Microsoft 365 roadmap ID: 124865.122KViews24likes169CommentsUsing Images for Dropdown Options in MS Lists
Greetings, I have a list on an internal company SharePoint 365 site where I'm trying to add the ability for users to select images instead of text from a choice column. I've stored the images on the same SharePoint site. I've added the below JSON code (with the actual links to the images, not the redacted text you see for company and department name) to the choice column's formatting field. However, the images just show up like this: Any ideas on what I'm doing wrong? { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "children": [ { "elmType": "img", "style": { "position": "relative", "top ": "50%", "left": "50%", "width": "24px", "height": "24px", "margin-left": "-50%", "margin-top": "0%" }, "attributes": { "img src": "=if(@currentField == 'Consistently Positive', 'https://MYCOMPANYNAME.sharepoint.com/:i:/r/sites/MYDEPARTMENTNAME/Shared%20Documents/_Resources/Trend%20Arrows/consistently%20positive%20trend%20(up%20arrow).png?csf=1&web=1&e=PalSfh', if(@currentField == 'Recently Positive', 'https://MYCOMPANYNAME.sharepoint.com/:i:/r/sites/MYDEPARTMENTNAME/Shared%20Documents/_Resources/Trend%20Arrows/recent%20positive%20trend%20(up-right%20arrow).png?csf=1&web=1&e=faw6kP', if(@currentField == 'Neutral','https://MYCOMPANYNAME.sharepoint.com/:i:/r/sites/MYDEPARTMENTNAME/Shared%20Documents/_Resources/Trend%20Arrows/neutral%20trend%20(right%20arrow).png?csf=1&web=1&e=YbDLiG', if(@currentField == 'Recently Negative','https://MYCOMPANYNAME.sharepoint.com/:i:/r/sites/MYDEPARTMENTNAME/Shared%20Documents/_Resources/Trend%20Arrows/recent%20negative%20trend%20(down-right%20arrow).png?csf=1&web=1&e=hk1MAM', if(@currentField == 'Consistently Negative','https://MYCOMPANYNAME.sharepoint.com/:i:/r/sites/MYDEPARTMENTNAME/Shared%20Documents/_Resources/Trend%20Arrows/consistently%20negative%20trend%20(down%20arrow).png?csf=1&web=1&e=CzakF5')))))" } } ] } Thanks in advance.20Views0likes1CommentMicrosoft Lists forms: What's New
Microsoft Lists forms help you get the specific details you need from various people and groups, without overexposing your full list and list details. With these improvements, you can create more dynamic, customized, and efficient forms, helping to streamline your workflows and gather more targeted data - and they look beautiful and load and submit quickly. Let's explore these updates in detail – first in a short demo video tour, and then more details below. Watch now: Seamless creation of forms with more customization Quick Creation of List Forms from Lists home, SharePoint, and the Lists app in Teams Creating list forms has never been easier, or more integrated. Now, users can get started with a form without first needing to create a new list. As you create your form from Lists home, SharePoint, or the Lists app in Teams, the underlying list for responses is created automatically behind the scenes. This seamless process saves you time and effort, allowing you to focus on collecting and managing your data. Conditional Branching Make your forms smarter and more dynamic with conditional branching. This feature allows you to show or hide questions based on previous answers, ensuring respondents only see questions relevant to them. This not only improves the user experience but also helps you collect more accurate and targeted data. Logo Support Brand your forms with your organization's logo. Adding a logo to your forms not only makes them look more professional, but it also reinforces brand identity. Create more relevant forms with additional field types Note the image above and the corresponding numbers to indicate new supported field types: 1. Location Collect location data with support for location columns on forms. Whether you're planning events, managing inventory, or tracking deliveries, this feature ensures you have accurate location information at your fingertips. 2. Image With image column support, you can now include images in your forms. This is particularly valuable on mobile browsers, where the form can access the device camera for quick image capture and upload. Ideal for audits, visual surveys, product feedback or any form where images can enhance the data collection process. 3. Lookup support Enhance your forms with lookup columns, enabling you to pull in data from other lists. This means that values from a column in another list can be displayed as choices on your form. This feature is particularly useful for creating relationships between different datasets, ensuring your forms are always populated with the most current information. However, please note that currently respondents need at least read access to the underlying source list to see and select the options. 4. Attachments Need to collect files or documents from your respondents? No problem! Our new attachment field support allows users to upload files directly to the form. This is ideal for scenarios like job applications, project submissions, or any situation where additional documentation is required. Enjoy greater control over your forms with additional settings Get Notifications for new form responses Choose to be notified the moment someone submits a response to your form. This feature ensures you stay on top of your data collection and can act promptly on new information, making your workflow more efficient and responsive. By default, this setting is turned off, but you can subscribe to the forms for which you wish to receive notifications. Allow single/multiple responses per user, per form Our new response settings provide you with control over how many times a user can respond to your form. You now have the option to permit either single or multiple responses per user, offering greater flexibility. This feature will be available shortly. Schedule when form submission starts and when it ends Timing is everything! With the new scheduling feature, you can set specific start and end dates for your forms. This is perfect for time-sensitive surveys, event registrations, or any scenario where you need to control when your form is available to respondents. Additional Lists improvements Link unfurling in Microsoft Teams Links to Lists, list items, and Lists forms will display richer details such as title and path when shared in Teams chats and channels. This new feature will enhance collaboration by making it easier for users to recognize specific List link types, in addition to viewing the title and path. Hide collaborators Based on customer feedback regarding privacy, admins can run the PowerShell command Set-SPOSite -Identity -HidePeopleWhoHaveListsOpen $true to disable this feature on a per-site collection basis, so users cannot see who is working on the list at the same time AND the lists still support co-authoring capabilities, just minimizes the visibility of your co-authors on that sites' lists. Learn more. In the end... We hope you are as excited as we are about these new features rolling out! Try them and see how they can transform your data collection and management processes. Our team is continuously working on new features and improvements to make Microsoft Lists forms even better. Stay tuned for more updates, and don't forget to share your feedback with us. Your input is invaluable in helping us shape the future of Microsoft Lists. Visit the Microsoft Lists resource center: https://aka.ms/MSLists Submit feedback: https://aka.ms/MSLists/Feedback Discover help and 'how to' content: https://aka.ms/MSLists/Help Enjoy, sahilbaid9.8KViews6likes18CommentsSharepoint List - Multiple IF AND function in calculated column
Hi, I'm trying to create a column that will calculate a value based on a risk matrix; I have come up with the formula below, but it's not working. I've also tried a switch formula without success. I've played around with swapping commas out for semicolons and removing line breaks but this also did not work. Can anyone assist with a solution please? So the calculation is based on a restricted list of values in Column [Likelihood] and a restricted list of values in Column [Consequence]. Thank you! =IF(AND([Likelihood]="Rare (1)",[Consequence]="Insignificant (1)"),"Low", IF(AND([Likelihood]="Rare (1)",[Consequence]="Minor (1)"),"Low", IF(AND([Likelihood]="Rare (1)",[Consequence]="Medium (3)"),"Low", IF(AND([Likelihood]="Rare (1)",[Consequence]="Major (4)"),"Moderate", IF(AND([Likelihood]="Rare (1)",[Consequence]="Critical (5)"),"High", IF(AND([Likelihood]="Unlikely (2)",[Consequence]="Insignificant (1)"),"Low", IF(AND([Likelihood]="Unlikely (2)",[Consequence]="Minor (1)"),"Low", IF(AND([Likelihood]="Unlikely (2)",[Consequence]="Medium (3)"),"Moderate", IF(AND([Likelihood]="Unlikely (2)",[Consequence]="Major (4)"),"Moderate", IF(AND([Likelihood]="Unlikely (2)",[Consequence]="Critical (5)"),"High", IF(AND([Likelihood]="Possible (3)",[Consequence]="Insignificant (1)"),"Low", IF(AND([Likelihood]="Possible (3)",[Consequence]="Minor (1)"),"Moderate", IF(AND([Likelihood]="Possible (3)",[Consequence]="Medium (3)"),"Moderate", IF(AND([Likelihood]="Possible (3)",[Consequence]="Major (4)"),"High", IF(AND([Likelihood]="Possible (3)",[Consequence]="Critical (5)"),"High", IF(AND([Likelihood]="Likely (4)",[Consequence]="Insignificant (1)"),"Moderate", IF(AND([Likelihood]="Likely (4)",[Consequence]="Minor (1)"),"Moderate", IF(AND([Likelihood]="Likely (4)",[Consequence]="Medium (3)"),"High", IF(AND([Likelihood]="Likely (4)",[Consequence]="Major (4)"),"High", IF(AND([Likelihood]="Likely (4)",[Consequence]="Critical (5)"),"Extreme", IF(AND([Likelihood]="Almost Certain (5)",[Consequence]="Insignificant (1)"),"Moderate", IF(AND([Likelihood]="Almost Certain (5)",[Consequence]="Minor (1)"),"Moderate", IF(AND([Likelihood]="Almost Certain (5)",[Consequence]="Medium (3)"),"High", IF(AND([Likelihood]="Almost Certain (5)",[Consequence]="Major (4)"),"Extreme", IF(AND([Likelihood]="Almost Certain (5)",[Consequence]="Critical (5)"),"Extreme",""))))))))))))))))))))))))Solved9.6KViews0likes4CommentsSharePoint Board view bucket limited to 9 or 10 items
Hi everyone, I have recently started using SharePoint list Board view which is perfect for my needs, however my buckets seem to be limited to a maximum of 10 items. When I drag the 10th item into the bucket I get a red circle with a cross appearing at the top of the bucket and the card I tried to move to that bucket is put back where i dragged it from. Screen shot below of the bucket heading and the icon I'm talking about. Can anyone tell me what is going on here and how I can fix this? Thanks in advance!14Views0likes0Comments