Is this correct ??
Switch(
[Dif Tarea] >= -5, "Verde",
[Dif Tarea] < -10, "Rojo",
[Dif Tarea] < -5 AND [Dif Tarea] >= -10, "Amarillo"
)
Help!!
The goal of this formula is to categorize the difference in task performance (represented by [Dif Tarea]) into three distinct categories, each represented by a color:
"GREEN" : This indicates that the task is performing well or is on track. "YELLOW" : This indicates that the task is at risk or needs attention. "RED" : This indicates that the task is significantly behind or in trouble.