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

Question

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 passed & [Arrival Date] is empty = red

Thank you!

bullseyebullsey · Answer

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

bullseyebullsey · Answer

Also, here is a color picker you can try if you don't like the shades I picked:https://www.w3schools.com/colors/colors_picker.asp

kellybianchi · Answer

Here is the error I get:Formula syntax errorExpected a valid expression after the "="If([Arrival Date]=&nbsp;&nbsp;��,Case([ETA],1=ToDays([ETA]-Today()),�#ffff00�,[ETA]=Today(),�#00ff00�,ToDays([ETA]-Today())&lt;0,�#ff0000�),��)

bullseyebullsey · Answer

Try .....[Arrival Date]=ToDate(""),.....

kellybianchi · Answer

This is what I got:Formula syntax errorPlease 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()),&nbsp;&nbsp;�#ffff00�,[ETA]=Today(),�#00ff00�,ToDays([ETA]-Today())&lt;0,�#ff0000�),��)

Forum Discussion

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

9 Replies

Related Content

Set Current Time?

Do unused tables related to currently used tables cause functionality problems?

Saved Value is not registering before redirect

Save Before Navigating and API Edit Record Bug - Not bug...

Color coding formula

Recent Discussions

Calendar Reports not Loading

Pipelines and Filters

"Button" Data Refresh Quirk

Year Formula help

Passing fields from Child to Parent