Change the color of text in a Dashboard List, based on the Value (Yes/No, or Pass/Fail, etc.).

Question

I’m trying to use the “Advanced formatting” section in a Dashboard List to change the color of the text for a field based on the attribute value of that field (e.g., “Yes” = Red, “No” = Green)

I’ve seen examples that have similar solutions, but I can’t figure out how to make it work for this specific example. Also, I’m not much of a coder, so any help would be greatly appreciated.

Thanks

List.JPG

image.png

AugustKaster · Answer

If you have multiple conditions, you can also achieve this with Decode():

return {
  textColor:
  Decode($datapoint.EngStatus,
    "Project Created", "#0084A8",
    "In Design", "#00A9E6",
    "Design Complete", "#73DFFF",
    "In Construction", "#FFAA00",
    "Asbuilt Ready", "#98E600",
    "Project Complete", "#38A800",
    "On Hold", "#E60000",
    "Cancelled", "#6E6E6E",
    ""),
  backgroundColor: '',
  separatorColor:'',
  selectionColor: '',
  selectionTextColor: '',
  // attributes: {
    // attribute1: '',
    // attribute2: ''
  // }
}

MarkDuvall_ccec · Answer

Thanks Josh!

jcarlson · Answer

The simplest is to use Iif to assign the color based on the field. For something this direct, you don't even need to mess around with variables. Put this in your advanced formatting section:

return {
  textColor: Iif($datapoint['fail'] == 'Yes', 'red', 'green')
}

Feel free to swap the color names with hex codes to get the colors how you want them.

Edit: I had my red and green mixed up! Edited the code block.