Checking a box if current month

Options

Hello,

I am trying to check a box if the "Next MI Date" is equal to the current month. Here's the formula I have but even when the "Next MI Date" is 02/01/2023 it is not checking the box.

=IFERROR(IF(MONTH(TODAY()) = MONTH([Next MI Date]@row), IF(YEAR(TODAY()) = YEAR([Next MI Date]@row), 1, 0)), 0)

What am I missing?

Thank you,

Lisakay

Answers

  • Chris Shifflett
    Options

    =IF(MONTH([Next MI Date])=MONTH(TODAY()),TRUE,FALSE)

    It is possible that the date format of the "Next MI Date" column is incorrect, which is causing the formula to not work as expected. To resolve this issue, you can change the date format of the "Next MI Date" column to "MM/DD/YYYY".

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!