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)

Related Content

Color Code Date Field based on Formula

Color Coding based on field value

Show unique parent records for current user

create pipeline to create new records based on current record

When the Expiration Date is On or Before Today, Change the Contract Status to Expired