Help

Auto Checkbox

Topic Labels: Automations Formulas
Solved
Jump to Solution
420 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!