I have the following value 2022-06-01, 2022-12-05 and I need a formula that checks whether:
2022-06-01 is after TODAY()
or 2022-12-05 is after TODAY()
How can I do that? Doing that with a single date (e.g: 2022-06-01) is easy, but how can I handle that for a list?
Note: 2022-06-01, 2022-12-05 is a rollup value of a one-to-many relationship, I don’t think I can use the relationship to perform any kind of calculation there, though. (I don’t see how that would help)
Thanks for the pointers, I had simplified the problem voluntarily.
I don’t think automations can help in this case (too many would be triggered at each change), and putting the formula in “Table 1” won’t help, because the formula isn’t actually a simple “is after today” comparison, but a comparison with a date that is specified elsewhere, and looked up in “Table 2”.
I was thinking about using a formula that parses each date distinclty, and checks whether any of those passes the filter (which is “is after today?”, in this example)