Can somebody help trying to read only data from this Month



My plan is to bring data from the current month, from a different sheet using cross sheets formulas. My code below is not working any idea why? It says #UNPARSEABLE

Any help is much appreciated

=SUMIF({Actual Completion Date}@row)=MONTH(TODAY()),({Completed Jobs Value})



  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Eric Goldsmith

    It looks like there are a few syntax errors here that we can iron out. For the CRITERIA portion after the first range, we need to state that you're looking for the MONTH in each cell (@cell) of that column to see if it equals today's month.

    MONTH(@cell) = MONTH(TODAY())

    However we can sometimes get errors with the MONTH function if there are blank cells in the range, so lets add an IFERROR statement, like so:

    IFERROR(MONTH(@cell), 0)

    Try this:

    =SUMIF({Actual Completion Date}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), {Completed Jobs Value})

    Let me know if this works!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!