If Date is passed, check the other column



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.



I figured it out myself!

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

Then filter out “archive”

1 Like

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