Sheet Summary Formula - All Completed Tasks in the last 30 days

Good morning,

I am trying to add the total number of closed items within the last 30 days. I have used a lot of the suggested formulas in past posts, but it is still counting ALL completed tasks (72) instead of the tasks completed in the last 30 days (40).

I'm not sure if it's because it's a sheet summary and not within the sheet itself? I am using the following formula, tried it with and without an AND statement.

=COUNTIFS(Status:Status, "Complete", Modified:Modified, <=TODAY(), Modified:Modified, >=TODAY(-30))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!