Last 7 days

I am trying to create a formula that will pull data from two columns in the sheet as follows:

Sheet columns include intakes by location and a date entered column. I want to create a roll up at the top to show intakes by location in the last 7 days that automatically updates.

Here is what I have:

=COUNTIF([Location:Location], "Main") AND ([Date],>TODAY(-7))

I'm not sure how to correct.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!