Aug 04 2020 11:51 PM
Hi,
I have a column with a header that contains date intervalls for project activities (e.g. 21.05.2020 - 10.10.2020). In the header I would like to filter only activities that are valid within a spesific time period (e.g. July 2020). The problem is that the filter function in the drop down menu only allows for activities ONLY taking place in July to show, not those that span across July AND other months.
Is there any way around this? The date intervalls in the column are exported from another sheet in the same workbook.
Best,
Mags
Aug 05 2020 12:04 AM
Hard to tell unless you upload a sample file to visualize what exactly you are trying to achieve.
Maybe you can insert two helper columns, one having the start time interval and another having the end time interval and then you can filter your data based on the helper columns.
Aug 05 2020 12:37 AM