automatic numbering in lists

Question

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 assigned its own ID i.e. so that I don't have to manually enter 'Risk 1', 'Risk 2' etc - that's going to got wrong pretty soon...

Any suggestions greatly appreciated 🙂

robelliott · Answer

jacobite&nbsp;the most robust method is just to use the ID column as that will always give you a unique number.&nbsp;RobLos GallardosIntranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

jacobite · Answer

@RobElliot - thanks for taking the time to reply. Is the ID column a standard option in lists? - i don't see it...

robelliott · Answer

jacobite&nbsp;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.&nbsp;&nbsp;&nbsp;RobLos GallardosIntranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

jacobite · Answer

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?

robelliott · Answer

jacobite&nbsp;and it's easy enough in a SharePoint list as well with JSON column formatting. In this example Probability is a number column with decimal points set to 0, so is Impact. RiskScore is a calculated column with the formula =[Probability]*[Impact]. Then click the dropdown next to RiskScore, select Column settings and then select Format this column. Select Advanced mode, clear everything and paste in the following JSON:&nbsp;{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "background-color": "=if(@currentField &gt;= 15, 'red', if(@currentField &gt;=10 &amp;&amp;@currentField&lt;15, 'gold','green')",
    "color": "=if(@currentField &gt;= 15, 'white', if(@currentField &gt;=10 &amp;&amp; @currentField&lt;15, 'black','white')",
    "padding-left": "4px"
  }
}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;That will result in this:&nbsp;Of course you can change the parameters, colors or add more if you need to.&nbsp;RobLos GallardosIntranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Forum Discussion

automatic numbering in lists

Share

Resources