I'm currently using SharePoint column formatting JSON to turn a field's string entry into a text, based on it's value.
For instance:
whenever @currentfield is equal to number 10, it should replace the number 10 with "Hello"
whenever @currentfield is equal to number 20, it should replace the number 20 with "Bye",
Otherwise do nothing.
Is there a simple way to do that?
Use below JSON for you column:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "=if(@currentField == 10, 'Hello', if(@currentField == 20, 'Bye', ''))"
}
Output:
Before applying JSON:
After applying JSON:
If you want to keep @currentField value as it is for 3rd condition, use:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "=if(@currentField == 10, 'Hello', if(@currentField == 20, 'Bye', @currentField))"
}
Output:
