Help

Formula for checkbox active record

Topic Labels: Formulas
640 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Didi_Kerkhofs
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!

Best,
Didi

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

JB