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.

Formula for checkbox active record

Topic Labels: Formulas
454 1
Showing results for 
Search instead for 
Did you mean: 

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