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

✭✭✭✭✭✭

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.

• ✭✭✭✭✭✭

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.

• ✭✭✭✭✭✭

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

• ✭✭✭✭✭✭

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

• ✭✭✭✭✭✭

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.

• ✭✭✭✭✭✭

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

• ✭✭✭✭✭✭

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!