Skip to main content
Question

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

  • September 4, 2017
  • 0 replies
  • 84 views
Forum|alt.badge.img+6
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.
    This topic has been closed for replies.

    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.
    Forum|alt.badge.img+6
    I just moved it around, and it still isn't showing the blank value in blue over the ETA condition in green.
    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?
    Terms & ConditionsAccessibility statement