Formula calculating monthly totals

steve50951 ✭✭
edited 12/09/19 in Formulas and Functions

I am trying to write a formula that will calculate receipt totals by month (starting this month)

Here is the formula i am using, but it is returning an invalid data type

=SUMIFS({Joseph Nelums- CRS Expense Reporting Receipt Total}, {Joseph Nelums- CRS Expense Reporting Date}, YEAR(@cell) = YEAR(TODAY()), {Joseph Nelums- CRS Expense Reporting Date}, MONTH(@cell) = 4)

Thanks for you help!

Screen Shot 2019-04-26 at 12.10.04 PM.png

Screen Shot 2019-04-26 at 12.12.24 PM.png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!