Need a Formula to Show if Current Month & Year (in a checkbox)

=IFERROR(IF(AND(MONTH(TODAY) - MONTH(Date@row) = 0, (YEAR(TODAY) - YEAR(Date@row) = 0)), 1, 0))


I want to check the "Current Month & Year" column from the Date column if true, so I can roll reports and data for next year.

Not sure if my attempt is close or not!!

Thanks in advance.


Best Answer


  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @Steve Dearing

    Yes, only a small tweak is needed. Your TODAY function needs to be written as TODAY(). Also, the IFERROR function is wrapped completely around another function or formula. First write your formula, parentheses and all, then wrap the IFERROR around it. You must designate what happens in the event of error.

    Your formula logic will work perfectly. I'll offer another approach

    =IFERROR(IF(AND(MONTH(Date@row)=MONTH(TODAY()), YEAR(Date@row)=YEAR(TODAY()), 1),"")

    Will this work for you?


  • Hi Kelly

    used your approach and came back with "incorrect argument set"

    =IFERROR(IF(AND(MONTH(Date@row) = MONTH(TODAY()), YEAR(Date@row) = YEAR(TODAY()), 1), ""))


  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    grrr. my bad. I rushed and didn't close the AND clause.

    =IFERROR(IF(AND(MONTH(Date@row) = MONTH(TODAY()), YEAR(Date@row) = YEAR(TODAY())), 1), "")

  • Steve Dearing
    Answer ✓


    Thanks Kelly

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!