If Date is passed, check the other column

#1

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

I figured it out myself!

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

Then filter out “archive”

1 Like
#3

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.

1 Like