Forum Discussion
Hide a column that is part of the format view
I have a column for overall status that is set with a flow and should not be visible for the users. Based on the value of the column, I mark the rows red, yellow or green. The problem is that this formatting only works if the column is a part of the view.
Is there anyway to get around this? My json formatting is like this:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
"schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
"additionalRowClass": "=if([$Overornet_x0020_status]=='OK','sp-css-backgroundColor-BgMintGreen sp-field-fontSizeSmall sp-css-color-MintGreenFont',if([$Overornet_x0020_status]=='Litt kritisk','sp-css-backgroundColor-BgGold sp-css-borderColor-GoldFont sp-field-fontSizeSmall sp-css-color-GoldFont',if([$Overornet_x0020_status]=='Kritisk','sp-css-backgroundColor-BgDustRose sp-field-fontSizeSmall sp-css-color-DustRoseFont',''))"
}
No RepliesBe the first to reply