Microsoft Lists - Questions and sgugestions

%3CLINGO-SUB%20id%3D%22lingo-sub-2415862%22%20slang%3D%22en-US%22%3EMicrosoft%20Lists%20-%20Questions%20and%20sgugestions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2415862%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20suggested%20Microsoft%20Lists%20to%20one%20of%20our%20staff%20members%20to%20manage%20some%20data%20and%20it's%20working%20pretty%20well.%20I've%20also%20been%20using%20it%20for%20my%20own%20needs%20and%20find%20it%20quite%20useful.%20However%2C%20we've%20faced%20the%20following%20issues%20while%20working%20with%20it%2C%20and%20was%20wondering%20if%20anyone%20had%20found%20a%20way%20to%20fix%20these%20issues%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%20class%3D%22y-list%20y-list__unordered%20yj-redraft-list%22%3E%3CLI%3EThe%20order%20in%20which%20I%20added%20my%20columns%20in%20the%20grid%20view%20(quick%20edit)%20is%20not%20the%20same%20as%20when%20I%20add%20an%20item%20in%20the%20form%20view%20(New%20Item).%20Is%20there%20an%20easy%20way%20to%20change%20this%3F%3C%2FLI%3E%3CLI%3EWhen%20we%20add%20items%20in%20a%20multiple%20choices%20question%2C%20we%20can't%20reorder%20the%20items%20(like%20in%20alphabetic%20order).%20If%20we%20want%20to%20do%20this%2C%20we%20need%20to%20delete%20everything%20and%20retype%20again.%20Is%20there%20an%20easier%20way%3F%3C%2FLI%3E%3CLI%3EWhen%20you%20create%20a%20new%20list%2C%20the%20Title%20column%20is%20stuck%20(we%20can't%20remove%20it%20if%20we%20don't%20need%20it).%3C%2FLI%3E%3C%2FUL%3E%3CP%3EI%20also%20had%20these%20feature%20requests%3A%3C%2FP%3E%3CUL%3E%3CLI%3EPossibility%20to%20view%20many%20lists%20in%20one%20view%3C%2FLI%3E%3CLI%3EGantt%20chart%20view%20instead%20of%20just%20calendar%20view%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2415862%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2416153%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Lists%20-%20Questions%20and%20sgugestions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2416153%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F930671%22%20target%3D%22_blank%22%3E%40MelanieR%3C%2FA%3E%26nbsp%3Bto%20re-order%20the%20columns%20in%20your%20form%20to%20match%20the%20list%20column%20order%20clcik%20New%20then%20select%20the%20pen%20%26amp%3B%20paper%20icon%20in%20the%20top%20right%2C%20select%20Edit%20columns%20and%20thyen%20you%20can%20drag%20each%20column%20to%20a%20new%20position%20or%20click%20the%20ellipses%20to%20manually%20move%20them.%20When%20you%20are%20happy%20with%20the%20order%20click%20Save.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22changeColumnOrder.png%22%20style%3D%22width%3A%20887px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F286282i7AF1A4559F66B7AD%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22changeColumnOrder.png%22%20alt%3D%22changeColumnOrder.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20currently%20no%20way%20to%20re-order%20the%20choices%20in%20a%20Choice%20type%20column.%20Also%20you%20can't%20currently%20delete%20the%20Title%20column.%2C%20but%20you%20can%20rename%20it%20which%20means%20you%20don't%20have%20to%20create%20a%20column%20to%20replace%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%2C%20Website%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2416572%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Lists%20-%20Questions%20and%20sgugestions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2416572%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40RobElliott%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EHi%20Rob%2C%3C%2FP%3E%3CP%3EThanks%20for%20your%20reply!%3C%2FP%3E%3CP%3EI%20just%20checked%20in%20my%20list%20and%20I%20don't%20seem%20to%20have%20that%20same%20pen%20and%20paper%20icon%20you%20are%20showing%20in%20your%20screen%20capture.%20Here%20is%20what%20I%20have%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MelanieR_0-1622819728427.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F286297i71D7F176C1131603%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22MelanieR_0-1622819728427.png%22%20alt%3D%22MelanieR_0-1622819728427.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20tried%20to%20look%20around%20in%20my%20options%20and%20saw%20a%20page%20similar%20to%20what%20you%20were%20showing%2C%20but%20when%20I%20changed%20the%20order%20it%20only%20changed%20it%20in%20my%20quick%20edit%20view%20once%20again.%20Maybe%20I%20just%20need%20to%20wait%20for%20an%20upgrade%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone,

 

I suggested Microsoft Lists to one of our staff members to manage some data and it's working pretty well. I've also been using it for my own needs and find it quite useful. However, we've faced the following issues while working with it, and was wondering if anyone had found a way to fix these issues:

 

  • The order in which I added my columns in the grid view (quick edit) is not the same as when I add an item in the form view (New Item). Is there an easy way to change this?
  • When we add items in a multiple choices question, we can't reorder the items (like in alphabetic order). If we want to do this, we need to delete everything and retype again. Is there an easier way?
  • When you create a new list, the Title column is stuck (we can't remove it if we don't need it).

I also had these feature requests:

  • Possibility to view many lists in one view
  • Gantt chart view instead of just calendar view

 

Thanks!

4 Replies

@MelanieR to re-order the columns in your form to match the list column order click New then select the pen & paper icon in the top right, select Edit columns and then you can drag each column to a new position or click the ellipsis to manually move them. When you are happy with the order click Save.

 

changeColumnOrder.png

 

There is currently no way to re-order the choices in a Choice type column. Also you can't currently delete the Title column., but you can rename it which means you don't have to create a column to replace it.

 

Rob
Los Gallardos
Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)

 

 

@RobElliott 

Hi Rob,

Thanks for your reply!

I just checked in my list and I don't seem to have that same pen and paper icon you are showing in your screen capture. Here is what I have:

MelanieR_0-1622819728427.png


I tried to look around in my options and saw a page similar to what you were showing, but when I changed the order it only changed it in my quick edit view once again. Maybe I just need to wait for an upgrade?

Thanks!

You have to click New/Nouveau first then the icon appears.

@MelanieR To show/hide or reorder the columns in list view, you can follow below steps:

1. Go to SharePoint list

2. Scroll horizontally to the right, at the end you will see Add column option like:

 

ganeshsanap_0-1622829024051.png

 

3. Click on Add column, it will open a pop up --> select last option Show/hide columns

4. It will open Edit view columns panel at the right side where you can choose which columns you want to show in list view

5. Also, you can drag the column names to change the order or you can move up/down the column using the button as shown in below image:

ganeshsanap_1-1622829262237.png

 

Reorder choices: Check my answer given here

 

About Title column: You can - 

  1. Rename & use it store data for some other field
  2. Make the Title column optional
  3. You can make the column hidden from list form. Check Hide Title section

Gantt Chart: You can create Gantt chart view in classic experience of list. Check this article 

 

About many lists in one view

You cannot show multiple lists in single view. You can create multiple view within a list or you can create a SharePoint page & add multiple lists to page using the List web part 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.