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

• 0
• Question
• Updated 2 years ago
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 based on the date formulas. I have attempted to create a line item for each date formula combined with the text formula. It doesn't seem to be working. Here is what I have so far:

If(
not IsNull([Time Complete]), "",
([ETA:])>Now(),"#08ef08",
([ETA:])<Now() and ToDays([ETA:]-Now())>-1, "#f9fc03",
ToDays([ETA:]-Now())<0,"#fd3110",
IsNull([ETA:]),"#00f6ff",
(Trim([Van Driver]))<>"" and ([ETA:])>Now(),"#00f6ff")

The last line is the only one not working.
• 1,812 Points

Posted 2 years ago

• 0

QuickBaseCoach App Dev./Training, Champion

• 67,278 Points
Are your conditions listed in their priority?
The IF statement evaluates the tests in the order they are liste and stops at the first one which is true.
• 1,812 Points
I just moved it around, and it still isn't showing the blank value in blue over the ETA condition in green.

QuickBaseCoach App Dev./Training, Champion

• 67,278 Points
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?

QuickBaseCoach App Dev./Training, Champion

• 67,278 Points
Also, if Van Driver is a text field,  why not just use

Trim([Van Driver])<>"","#00f6ff",
• 1,812 Points
Then I get this:

Not only is the field with no Van Driver not blue, but everything else that shouldn't be - is!
• 1,812 Points
I figured it out!

If(
not IsNull([Time Complete]), "",
(Trim([Van Driver])="" and ([ETA:])>Now()), "#00f6ff",
(Trim([Van Driver])="" and ([ETA:])<Now() and ToDays([ETA:]-Now())>-1),"#00f6ff",
(Trim([Van Driver])="" and ToDays([ETA:]-Now())<0),"#00f6ff",
([ETA:])>Now(),"#08ef08",
([ETA:])<Now() and ToDays([ETA:]-Now())>-1, "#f9fc03",
ToDays([ETA:]-Now())<0,"#fd3110",
IsNull([ETA:]),"#00f6ff")

QuickBaseCoach App Dev./Training, Champion

• 67,278 Points
Congratulations.
What I often do when using those hex color codes is to add a comment

(Trim([Van Driver])="" and ([ETA:])>Now()), "#00f6ff", // blue

You can add a comment by starting a line with // or even suffixing a line with //, like I did above.

That way when you go back to look at your formula you will remember what those color codes mean.
• 1,812 Points
Great idea! Thank You!