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!
I figured it out myself!
IF({Gate Issue Date}< TODAY(), “Archive”, “Current”)
Then filter out “archive”
+21I 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.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.