Skip to main content

Hi all!

I think this would be super helpful to have programed as a default. "within (number of days) of date chosen, date will highlight as (choose color)


Short of that, is there a way to script this?


Thank you,

B

Hi @Barry,


welcome to Airtable community! This is possible but it is required to have a Pro plan in Airtable because the coloring option is in available on that plan.


Then you can create a formula field which will check the conditions of formatting. For example for 30 days before a date, the date has to be formatted:



IF(DATETIME_DIFF({your_date_field},now(),‘dasys’)<30,“red color”,“blue color”)



The next step is to set up a conditional formatting like the “red color” with the red color.


Please text us back if it works for you.


Thanks

Dimitris Goudis


Reply