Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Auto Checkbox

Topic Labels: Automations Formulas
Solved
Jump to Solution
1211 2
cancel
Showing results for 
Search instead for 
Did you mean: 
elcharleston23
4 - Data Explorer
4 - Data Explorer

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!

1 Solution

Accepted Solutions
Marcelo
6 - Interface Innovator
6 - Interface Innovator

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"

See Solution in Thread

2 Replies 2
Marcelo
6 - Interface Innovator
6 - Interface Innovator

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!