Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

If Date is passed, check the other column

Topic Labels: Formulas
1432 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello!

Could you help me with a formula? We’d like to archive everything with a date in the past. Right now, we’re checking a box that then causes the entry to filter out. Is there a way to automate this? I was thinking an If statement (If the publication column’s date is prior to the current date, check the archive column), but I can’t figure out the exact language.

Thanks!

2 Replies 2

I figured it out myself!

IF({Gate Issue Date}< TODAY(), “Archive”, “Current”)

Then filter out “archive”

You could even do this without a formula. Create a filter where {Gate Issue Date} is on or after today, and you can nix the formula field entirely.