Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Jul 16, 2019 12:25 AM
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
Jul 16, 2019 12:48 AM
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