formula to figure date 3 months out and check a box if today is the 3 month date

Peggy Parchert

I'm trying to setup an alert that will go to a Slack channel when a date is reached. I have the following columns in my sheet:

Alpha (checkbox column)

Unscored Date (date column)

3 mths (checkbox column)

I am wanting to check the 3 mths box for a line item if the date from the Unscored Date column is 90 days out.

Here is the formula I have in the 3 mths column and it's not working. I'd like to make this a column formula column (the 3 mths column) so I need to look at blank dates in Unscored Date column as well as those lines that have dates.

=IF(AND(Alpha@row = 0, ISBLANK([Unscored Date]@row), 0)), IF(AND(Alpha@row = 1, [Unscored Date]@row = TODAY()), 1, 0))

Any assistance would be appreciated.

Paul Newcome

Try this...

=IF(AND(Alpha@row = 1, [Unscored Date]@row = TODAY(90)), 1)

If the Alpha box is checked and the [Unscored Date] is 90 days in the future, it will check the box.

Paul Newcome

90 days in the future or 90 days in the past?

Peggy Parchert

@Paul Newcome - 90 days in the future - I should have said that.

Paul Newcome

Try this...

=IF(AND(Alpha@row = 1, [Unscored Date]@row = TODAY(90)), 1)

If the Alpha box is checked and the [Unscored Date] is 90 days in the future, it will check the box.

Peggy Parchert

Thank you @Paul Newcome - that worked! Appreciate all your help!

Paul Newcome

Happy to help. 👍️