Formula for checkbox active record

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!


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:

with the formula:

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


1 Like