Forum Discussion
automatic numbering in lists
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)
- jacobiteSep 06, 2022Copper ContributorRobElliott - 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?- RobElliottSep 06, 2022Silver Contributor
jacobite 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:
{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "background-color": "=if(@currentField >= 15, 'red', if(@currentField >=10 &&@currentField<15, 'gold','green')", "color": "=if(@currentField >= 15, 'white', if(@currentField >=10 && @currentField<15, 'black','white')", "padding-left": "4px" } }
That will result in this:
Of course you can change the parameters, colors or add more if you need to.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- jacobiteSep 07, 2022Copper ContributorRobElliott sincere thanks for such a detailed and helpful response. Much appreciated.