Auto Checkbox

[elcharleston23]

Is there a formula to have a checkbox automatically checked if the current date is later than a specific date field in that record?  We want to be able to sort by "eligible" records and have it automatically updated as each goes past its "eligible date."  

Thanks!

[Marcelo · Accepted solution]

instead of using a checkbox column you could use an emoji.
For example: if date1 is after date2, then 🟢, otherwise 🔴.
this serves the same purpose for filtering, which you can then use in automations and views.
To check the dates you should use the formula "is_before"

[elcharleston23]

This is perfect thanks!