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!
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"
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"
This is perfect thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.