Hello, everyone,
Probably a simple question, but I can’t figure out if and how to do it?
I want to format a field, but in a dependency to another field. Is that possible? For example:
If field A has the value 1, field B should be red if >10, green if <10. If field A has the value 2 then field B should be green at >20 and green at <20.
I already know this, but unfortunately it does not help me with my question. My problem is that I want to set the selected color in relation to another field. Is that possible?
Hi @jom.
In the meanwhile you could incorporate in your SQL code the logic by using a third column, and show there as Text RED, GREEN. And do a conditional on the third column.