Uncheck Box

Genesia

I have a formula that says IF(Date@row<TODAY(-14),1,0), to add a checkmark, but how do I add a formula that says once a next recurring date has been added to remove this checkmark.

Deric

I like to get rid of the event first:

=IF([Next Recurring Date]@row <> "", 0, IF(Date@row < TODAY(-14),1,0))

It might make more sense to think of it this way though:

=IF([Next Recurring Date]@row = "", IF(Date@row < TODAY(-14), 1), 0)

Deric

I like to get rid of the event first:

=IF([Next Recurring Date]@row <> "", 0, IF(Date@row < TODAY(-14),1,0))

It might make more sense to think of it this way though:

=IF([Next Recurring Date]@row = "", IF(Date@row < TODAY(-14), 1), 0)