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

Options

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

Hi

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.

Tags:

Best Answer

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    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?

    Kelly

  • Steve Dearing
    Options

    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), ""))


    Steve

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    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
    Steve Dearing ✭✭
    Answer ✓
    Options

    Perfect

    Thanks Kelly

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!