So many great tools but so much overlap that it can cause an analysis paralysis. Microsoft; Lists, Tasks, Planner, One Note, Flow... I wish some MVP would make a great video to clarify the differences in applicability of each app and untangle this spaghetti of Microsoft solutions.
Hi, I have ColumnA and ColumnB. ColumnA is Text type and ColumnB is Choice type. How to show the values of ColumnA as choice options in Column (instead static values).
Thanks for your feedback. You absolutely can, and it’s through your Site Settings in SharePoint. Head to the Cog Icon and Site Settings and then under Regional Settings you can the Date and Time Locale Settings 😃
Sadly not, you can re-create the List into a Group / Team, by copying your existing List into the new List - but it will not copy or move your list items from your original list. You could do that final action using a Power Automate workflow, but it may be best just to copy and paste them into the new List (as copy and paste is supported when you click on 'Quick Edit' in the List) 😀
thank you so much! but i have tried many time to put the name like you do in Assigned to and issue logged but every time i'm able to just write the name with normal format like column in excel
No worries, you would need to ensure the Column Type is a 'People Picker' Column, rather than a 'Single Line of Text' as People Picker connects to your internal directory system and allows you to select a person internally
Well, each Row will appear as the most recent Row. However you could group Rows by a Column, so you could have each Item (Row) having a Column with a Project Name. You could then Group and Order a List View, by that Column Name - meaning all tasks will be grouped and be sequential 😃
@@your365coach thanks very much Scott! still not very practical. sometimes when we do projects we want to just insert a row right after another one. because of this, I'm really reluctant to use ms lists!
Great video! Is it possible to create a list for multiple teams for cross collaboration? It seems Lists can only be created within a single team and accessed by other teams via a Share link (adding members from other teams one by one). Not efficient when trying to add large groups. Perhaps you're aware of a better way to accomplish this?
Thanks for your question, and yes there are ways to achieve this. It does require effort to setup, but you could share a List with another MS Group or Group (inside the Sharing Link Dialog, you can actually share with a Team by typing in the name of the Team). However I just tested this and there were so many caveats in getting this working, that I may consider it in a future video, to cover it all off for you 😀
@your365coach I appreciate your response. Thank you! You noting this is doable but isn't very straightforward highlights my love/hate with Microsoft applications. They've got great products, but I wish more thought went into ease of use. Anyway, I look forward to your video should you decide to create one about this. Thanks.
Sure, the best way would be to use the Status Column with a Status of 'Completed' to mark when it's done, and then you can filter them out. Otherwise, you could also consider another Column such as a 'Yes / No' Column, with a Column Name of 'Completed' and then it can be marked off easily via that Column instead 😎
Thanks for your question, for Business Licensing would need either Business Basic, Business Premium or E1, E3. You can also use Lists in the Home or Family edition of Microsoft 365, it's just limited to be stored in your OneDrive if you use those versions 😀
There's not a concept of sub-task sadly in Microsoft Lists. However you can create another List, and then a column named a 'Lookup' and you can connect it to the other list, to create an associated connection. I know that sounds a bit fiddly, and i'll try to cover it in a future video 😀
So many great tools but so much overlap that it can cause an analysis paralysis. Microsoft; Lists, Tasks, Planner, One Note, Flow... I wish some MVP would make a great video to clarify the differences in applicability of each app and untangle this spaghetti of Microsoft solutions.
Well, I’m not an MVP but I’ll try and get a video produced like that for you 😊
I feel this...I feel Lists is actually more built out in MS Project
Oh My! So happy to have found this super helpful tutorial I'm definitely adding your channel to the top of my favorites. Thank you.
Thanks for that feedback Vinny, and I hope my other tutorials also help you too 😀
You save me from a mental breakdown, lol. Thank You. I couldn't see my list because it wasn't on my Sharepoint location.
Haha! Glad I helped with that and that’s why I created these videos, so glad I could help in some way 👍😄
Thank you for clear explanation.
Glad it was helpful!😊
Great content, clear and easy to understand please keep it coming 🤩
Thank you! Will do! 😊
Nice one Scott thanks mate for the effort. I have downloaded the book
Thanks for the feedback and I hope you enjoyed the ebook too? 😃
Hi, I have ColumnA and ColumnB. ColumnA is Text type and ColumnB is Choice type. How to show the values of ColumnA as choice options in Column (instead static values).
Thanks for this great video! Can the date format be changed to the UK format please?
Thanks for your feedback. You absolutely can, and it’s through your Site Settings in SharePoint. Head to the Cog Icon and Site Settings and then under Regional Settings you can the Date and Time Locale Settings 😃
I really liked this! If I have created a list and saved it to "My Lists", can I then move it to a Share Point or Team site?
Sadly not, you can re-create the List into a Group / Team, by copying your existing List into the new List - but it will not copy or move your list items from your original list.
You could do that final action using a Power Automate workflow, but it may be best just to copy and paste them into the new List (as copy and paste is supported when you click on 'Quick Edit' in the List) 😀
thank you so much! but i have tried many time to put the name like you do in Assigned to and issue logged
but every time i'm able to just write the name with normal format like column in excel
No worries, you would need to ensure the Column Type is a 'People Picker' Column, rather than a 'Single Line of Text' as People Picker connects to your internal directory system and allows you to select a person internally
Can we add row in the middle? Its a big problem if you want to make sequential tasks?
Well, each Row will appear as the most recent Row. However you could group Rows by a Column, so you could have each Item (Row) having a Column with a Project Name. You could then Group and Order a List View, by that Column Name - meaning all tasks will be grouped and be sequential 😃
@@your365coach thanks very much Scott! still not very practical. sometimes when we do projects we want to just insert a row right after another one. because of this, I'm really reluctant to use ms lists!
Great video! Is it possible to create a list for multiple teams for cross collaboration? It seems Lists can only be created within a single team and accessed by other teams via a Share link (adding members from other teams one by one). Not efficient when trying to add large groups. Perhaps you're aware of a better way to accomplish this?
Thanks for your question, and yes there are ways to achieve this. It does require effort to setup, but you could share a List with another MS Group or Group (inside the Sharing Link Dialog, you can actually share with a Team by typing in the name of the Team). However I just tested this and there were so many caveats in getting this working, that I may consider it in a future video, to cover it all off for you 😀
@your365coach I appreciate your response. Thank you! You noting this is doable but isn't very straightforward highlights my love/hate with Microsoft applications. They've got great products, but I wish more thought went into ease of use. Anyway, I look forward to your video should you decide to create one about this. Thanks.
How to check something as done? I’m using the issue tracker and don’t see that as an option…TIA!
Sure, the best way would be to use the Status Column with a Status of 'Completed' to mark when it's done, and then you can filter them out. Otherwise, you could also consider another Column such as a 'Yes / No' Column, with a Column Name of 'Completed' and then it can be marked off easily via that Column instead 😎
Which subscription plan should I choose to have lists as an app?
Thanks for your question, for Business Licensing would need either Business Basic, Business Premium or E1, E3.
You can also use Lists in the Home or Family edition of Microsoft 365, it's just limited to be stored in your OneDrive if you use those versions 😀
Hello, is there any possibility to create a subtask in the ms list?
There's not a concept of sub-task sadly in Microsoft Lists. However you can create another List, and then a column named a 'Lookup' and you can connect it to the other list, to create an associated connection. I know that sounds a bit fiddly, and i'll try to cover it in a future video 😀
@@your365coach thank you for your advice. would be great to see the video :)