Hello out there! Looking for some guidance and hints on how to format a list. Specifically I'm looking to evaluate 5 different fields and then color the text for that line item based on the value. Where I get hung up is trying to evaluate more than 1 field and then applying to color to only that field in the line item layout. I Don't want all text to be a color just the value from that field, if that makes sense.
Seems like a long If then statement but I can't wrap my head around the structure.
I have a 5 fields for completion that has an integer between 0 and 100 and null.
In my list I have each of these five fields as well as some other fields and text.
Hoping to color the text for the field if 0-33 = red, 34 - 66 = yellow and 67 - 99 = green, all else black.
var comp1 = $datapoint.pc_1
var comp2 = $datapoint.pc_2
var comp3 = $datapoint.pc_3
var comp4 = $datapoint.pc_4
var comp5 = $datapoint.pc_5
