Forum Discussion

KellyBianchi's avatar
KellyBianchi
Qrew Assistant Captain
8 years ago

How can I put 2 conditions (text and numeric) as independent conditions, and then combined?

I am using row colorization formulas, mostly based on a date/time field, which works. However, I need to add a condition regarding a text field, which would need to override the colorization rule base...
App builders
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Can you post you current formula, and tell me which line of the IF is not triggering and what the values are in each of the fields in that line?
KellyBianchi's avatar
KellyBianchi
Qrew Assistant Captain
8 years ago
I started to get closer. I changed to this, but now the blue is overriding the green:
If(
not IsNull([Time Complete]), "",
(Trim([Van Driver]))<>"" and ([ETA:])>Now() or (([ETA:])<Now() and ToDays([ETA:]-Now())>-1) or ToDays([ETA:]-Now())<0,"#00f6ff",
([ETA:])>Now(),"#08ef08",
([ETA:])<Now() and ToDays([ETA:]-Now())>-1, "#f9fc03",
ToDays([ETA:]-Now())<0,"#fd3110",
IsNull([ETA:]),"#00f6ff")

The line that was not triggering until I moved everything into one string was this one:
(Trim([Van Driver]))<>"" and ([ETA:])>Now() 

I was going to create a separate line for each, but then I decided to string it all together with 'or'. I am trying to make the rows green, red, or yellow based on the time in the 'ETA' field. However, I need the row to display blue if there is no ETA or if the van driver has not been assigned. I can't get the part to work to show blue when the van driver has not been assigned.