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�),��)