SUM and TODAY() function



I am building a formula to give me the SUM of the # of spots for dates called within the last 14 days. I was able to build a formula using the TODAY function:

=SUMIF({# of Spots}, <TODAY(), AND({Date Calleds}, <TODAY()))

However this formula returns a #INVALID DATA TYPE error.

I added a number to the TODAY function, and I get the same error.

=SUMIF({# of Spots}, <TODAY(-14), AND({Date Calleds}, <TODAY(-14)))

I am not sure how to make this function work.

Thank you



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!