Hello All,
Need help with figuring out, how to set advanced filter using criteria based on dates.
Objective :- Filter the data from the sheet - "Achievement Tracker" to the sheet - "Dashboard" based on multiple criteria's.
Requirement : The criteria's for filtering the data include - status, target month, completed month. For e.g., when I select the status as "in Progress" and then select the outlook month as Nov'19, then it should filter and show data for all "In Progress" entries with target date as "Nov'19". Likewise, one can filter based on achieved month and all entries which got completed in the selected month/year, should show up on the Dashboard.
Problem : I can filter based on single criteria, i.e. Status. But other criteria's based on month's/year is not working.
Kindly review and advise.
Thanks & Regards,
Shiju Cherian
Bookmarks