Forum Discussion
automatic numbering in lists
Hi - relative newbie. Not only that, but relative newbie creating a risk register using a list 🙂 Can someone tell me how a can configure a list in SP online so that each new item is automatically...
jacobite the most robust method is just to use the ID column as that will always give you a unique number.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
- @RobElliot - thanks for taking the time to reply. Is the ID column a standard option in lists? - i don't see it...
jacobite yes it is. Click the dropdown next to one of the column headings (it doesn't matter which one), select Column settings then Show/hide columns and select ID then click Apply.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- RobElliott - many thanks. Worked perfectly.
While I have your expert ear (or eyes), can you shed any light on how I can automatically change the colour of a cell based on the value of other cells i.e. Probability (3) x Impact (4) - 12 (turns the cell red).
Easy enough in Excel, but not sure about SP online?
