Formula for checkbox active record

[Didi_Kerkhofs]

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!

Best,
Didi

[JonathanBowen]

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, '✅')

JB