Help

If Date is passed, check the other column

Topic Labels: Formulas
1871 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Lauren_Anderson
6 - Interface Innovator
6 - Interface Innovator

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
Lauren_Anderson
6 - Interface Innovator
6 - Interface Innovator

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.