Formula to calculate revenue by date

I would like to write a formula to calculate revenue by month using the Created date.

I have tried the formula below and it's invalid operation.

=SUMIFS([Payment Amount]:[Payment Amount], AND(MONTH(@cell) = 1), Created:Created)

The date format in the created column is 05/04/23 1:09 PM.

Best Answer

  • Amy Shank
    Amy Shank ✭✭
    Answer ✓

    Thank you both for the timely response! I love this community! I was able to get the following to work:

    =SUMIFS([Payment Amount]:[Payment Amount], Created:Created, AND(@cell >= DATE(2023, 5, 1), @cell <= DATE(2023, 5, 31)))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!