Advance filter

[Mayur_K]

Hi,

1. I have prepared  google form for staff to apply for leave and linked that form to google app sheet.

2. now i want to create a report which shows from date and to date filter and when i select both dates it shows me list of only those employees who has taken leave during that period

[jkevz]

You can used the expression like this below:

IFS([Date]>=[Date From],LIST(List1,List2,List3),[Date]<=[Date To],List(List1,List2,List3) or please refer below link on how to write expression for dependent dropdown-list

https://support.google.com/appsheet/answer/10106620#:~:text=Dependent%20drop%2Ddowns%20allow%20you,a...