I am using a Board view to manage team tasks. One of the fields is the AssignedTo field which is a choice field with peoples' first names. I want to color the background color of the cards based on the person in the AssignedTo field.
I have tried using the JSON view formatting but it only works for the Title field in the list. If I add
"style": {
"background-color": "=if( [$Title] == '','#ffcccc', '#ffffff')"
},
to the formatter, it colors the background of all the cards that have null in the title field; however, if I try this with the Priority field ( Choice) or the AssignedTo field ( another choice field), it dosen't work.
I have tried using if( [$Title.lookupValue] as well as if ( [$Title] but nothing seems to work.
NOTE: I am using format view and not format column. Any ideas would be helpful.
"style": { "background-color": "=if( [$AssignedTo] == '','#ffcccc', '#ffffff')" }
. Also, make sure you have included/shown this column in your view. This is required in order to use the column in JSON formatting. Let me know if these suggestions helps you to solve your issue.