Where a date field has been placed in a sheet, is it possible to use dynamic dates to filter records?
This would be particularly useful when setting up useful fixed filters for my sales team. i.e. a dynamic list of filtered records containing customers departing for their holidays within the next 7 days?
Perhaps I can use a calculated field on a check box that can then be used to filter the the record? - if so, can you provide an example?