Formula Help: Is This Possible?

4

That’s great to read :raised_hands: !
And you seemed already really pretty close to make it work by saying this :point_down: @Chris_Hall :raised_hands:

If I decompose your sentences, this is what I read (and how I ended up with the formula) :blush: :

Step 1 of the filter:

If the field enddate is populated and its value is greater than today.

  • the field enddate is populated → thisRow.enddate.IsNotBlank()

    AND

  • its value is greater than today → thisRow.enddate > Today()

OR

Step 2 of the filter:

the field enddate is not populated, 
then if the field startdate is greater than today.

  • field enddate is not populated → thisRow.enddate.IsBlank()

    AND

  • the field startdate is greater than today → thisRow.startdate > Today()

And the whole filter works like this :blush: :

  • Step 1 will return True and keep the rows where both conditions thisRow.enddate.IsNotBlank() AND thisRow.enddate > Today() are True

  • Step 2 will return True and keep the rows where both conditions thisRow.enddate.IsBlank() AND thisRow.startdate > Today() are True

The whole filter will return True and keep the rows in the table for which either Step 1 OR Step 2 has returned True :blush:

2 Likes