Data change with date filter
I am trying to create a date filter that will change the sum of the data based on the date that is filtered.
Answers
-
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:
Cheers,
Genevieve
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!