Color coded answers from same list

ScottJones1

I have an extensive list, over 100 possible selections. However they are 3 distinct groups, Runs, Run Outs, Routes. So that they show up in a Dashboard under the same column in a Table, I have grouped them all together. I would like to see them with some individuality though, is there a way to create a calculation? that when an answer is from c4:c40 it displays blue, C41:C61 it displays red.....

clt_cabq

are you talking about displaying these color coded items in a list in the dashboard? You can use arcade in the advanced formatting section of the list configuration to do this probably. Here's some arcade I have that colors inspections by the number of days since a location was visited - red for over 100, orange for 60-100 days, and green for under 60 days, and a screen shot of what the list looks like. I don't know if tables offer the same kind of formatting though since I haven't worked with them.

// calculates the number of days since a location has been inspected, if greater than 100 days then the background turns Red
var daysSince = round(DateDiff(Today(), $datapoint.LastInsp,'days'))
// var alert = 100
var bkgrnd = When(
  daysSince > 100,'#FF7f7f',
  daysSince >= 60 && daysSince <=100,'#ffb461',
  '#8efc8d')
//var nextVis = $datapoint.nextVisit
var vistTxt = IIF($datapoint.nextVisit > 0,'Next visit is scheduled for' ,'No additonal visits have been secheduled at this time.')
var visDays = round(DateDiff($datapoint.nextVisit, Today(),'days'))
var daysTxt = IIF(visDays > 0, 'in ' + visDays + ' days','')
return {
  textColor: '',
  backgroundColor: bkgrnd,
  separatorColor:'',
  selectionColor: '',
  selectionTextColor: '',
    attributes: {
      numDays: daysSince,
      schedVis: vistTxt,
      schedDays: daysTxt,
    }
}