What is the formula I need to calculate the amount sum of a column for the past month? Then week?

Best Answers

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭
    edited 02/14/24 Answer ✓

    Try it like this:

    =SUMIFS([MP OP Daniel]:[MP OP Daniel], Date:Date, AND(IFERROR(MONTH(@cell), 0) = IF(MONTH(TODAY()) = 1, 12, MONTH(TODAY()) - 1), IFERROR(YEAR(@cell), 0) = IF(MONTH(TODAY()) = 1, YEAR(TODAY()) - 1, YEAR(TODAY()

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭
    Answer ✓

    Try wrapping entire formula in an IFERROR. You may need to manually type entire formula too. Sometimes the copy and paste can cause problems.

    =IFERROR(SUMIFS([MP OP Daniel]:[MP OP Daniel], Date:Date, IFERROR(WEEKNUMBER(@cell) = WEEKNUMBER(TODAY()) - 1, 0)), "")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!