Forum Discussion
444456464
Feb 24, 2022Copper Contributor
Show % symbol
Hello, I have a question. The columns I circled on my Sharepoint list are Number type columns and I checked the "percentage" box in the list settings. I would like to be able to display the % symbo...
444456464
Feb 25, 2022Copper Contributor
Thank you ! But I have already this in my column formatting : {
"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField",
"style": {
"color": "=if(@currentField >[$Tauxoccupationmaximal] , 'red', if(@currentField <[$Tauxoccupationmaximal], 'green' , 'orange')"
}
}
"$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
"elmType": "div",
"txtContent": "@currentField",
"style": {
"color": "=if(@currentField >[$Tauxoccupationmaximal] , 'red', if(@currentField <[$Tauxoccupationmaximal], 'green' , 'orange')"
}
}
RobElliott
Feb 25, 2022Silver Contributor
So just change the txtContent to what I gave you and add in the background color if you need it, or don't add it if you dont.