The following is part of JSON formatting in a SP List that turns rows red if field LookupFieldX
is empty:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
"additionalRowClass": "=if(length([$LookupFieldX.lookupValue])==0,'ms-bgColor-red','ms-bgColor-white'))))+ ' ms-fontColor-black'"
}
How do I extend the JSON so the empty field displays "TBD" in addition to the entire row being red? As you know, column formatting does not work for this because it is a lookup field.