Data change with date filter

Randy Mercado

I am trying to create a date filter that will change the sum of the data based on the date that is filtered.

Genevieve P.

Hi @Randy Mercado

It sounds like a Report will be a good option for you! You can use your sheet as the Source, then filter by your Date Column. Use the Summary feature to SUM your other column.

Then when you need to see other data, you can just adjust the filtered date range. Will that work for you?

Here's more information on Reports:

• Reports Help Article
• Webinar on Reports
• Webinar on using Summary in Reports

Cheers,

Genevieve