Sort by Year

Hi there.
I have been collecting data on my app for the year by date, etc.
I want to keep using the app without it resetting but want to allow user to only see data from the current year as default or they can see a past year of data, by using a choice menu ideally. NOt past 365 days but calendar year Jan 1 - 12/31

I can’t figure out how to do that within the app. Any suggestions?


1 Like

Use a math column to extract just the year from the date (Year(date)), and use that column as a filter.


Thank you! Now just trying to figure out how to integrate it into my app and on which sheet!