Jan 23, 2024 07:57 AM
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!
Solved! Go to Solution.
Jan 24, 2024 10:19 AM
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"
Jan 24, 2024 10:19 AM
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"
Jan 25, 2024 01:13 PM
This is perfect thanks!