Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Oct 25, 2021 11:53 AM
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
Oct 26, 2021 12:15 AM
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