Forum Discussion

KellyBianchi's avatar
KellyBianchi
Qrew Assistant Captain
8 years ago

Row colorization base on date (current, a day before, and past due)

I am trying to create the following colorization based on a date field: 1 day prior to [ETA] & [Arrival Date] is empty = yellow [ETA] = today's date & [Arrival Date] is empty = green [ETA] date has...
App builders
Formulas and functions
BullseyeBullsey's avatar
BullseyeBullsey
Qrew Cadet
8 years ago
I think this will work in the colorization formula:

If([Arrival Date]=��,Case([ETA],1=ToDays([ETA]-Today()),�#ffff00�,[ETA]=Today(),�#00ff00�,ToDays([ETA]-Today())<0,�#ff0000�),��)
  • KellyBianchi's avatar
    KellyBianchi
    Qrew Assistant Captain
    8 years ago
    Here is the error I get:
    Formula syntax error
    Expected a valid expression after the "="
    If([Arrival Date]=  ��,Case([ETA],1=ToDays([ETA]-Today()),�#ffff00�,[ETA]=Today(),�#00ff00�,ToDays([ETA]-Today())<0,�#ff0000�),��)
  • BullseyeBullsey's avatar
    BullseyeBullsey
    Qrew Cadet
    8 years ago
    Try .....[Arrival Date]=ToDate(""),.....
  • KellyBianchi's avatar
    KellyBianchi
    Qrew Assistant Captain
    8 years ago
    This is what I got:

    Formula syntax error

    Please check the syntax of your entire formula. Possible culprits are a mismatched set of parentheses, missing quotes, or an extra bracket.
    If([Arrival Date]=ToDate(""),Case([ETA],1=ToDays([ETA]-Today()),  �#ffff00�,[ETA]=Today(),�#00ff00�,ToDays([ETA]-Today())<0,�#ff0000�),��)
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    try this

    If(
    not Isnull([Arrival Date]), "",
    ToDays([ETA]-Today()) = 1,  "#ffff00",
    [ETA]=Today(),"#00ff00",
    ToDays([ETA]-Today())<0,"#ff0000")

    be sure you are using the straight double quotes and not the "66" "99" quotes which you see in Word.
  • KellyBianchi's avatar
    KellyBianchi
    Qrew Assistant Captain
    8 years ago
    I did change the quotes, because I thought that was it, but this formula worked. Thank you!!
  • KellyBianchi's avatar
    KellyBianchi
    Qrew Assistant Captain
    8 years ago
    Actually, had to change [ETA]=Today() to ToDays([ETA]-Today())>0, but I have what I need. Thanks again!
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    OK great, I did not have the time to check your logic, only your syntax.