Formula for checkbox active record

Topic Labels: Formulas
764 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hey there,

I am a total Airtable rookie and I am wondering how I create a formula for the following case:

I want to create a field that has a marked checkbox when the record is active. The record is active when the date in the field ‘Move out’ is today or less than today.

Thanks for your help!


1 Reply 1

Hi @Didi_Kerkhofs - you can’t have an Airtable checkbox field that is automatically populated (at least not without going outside of Airtable to, e.g. Zapier), but you can do this:

Screenshot 2019-07-16 at 08.46.17.png

with the formula:

IF(DATETIME_DIFF(TODAY(), {Move out}, 'days') >= 0, '')