Proper Syntax for Filtering and Grouping a Stretch Height Gallery

[Anonymous]

Hi All,

I would like to filter my GroupBy function.

The Gallery I am working in is Labeled: Time Sheets

This is my GroupBy function:

GroupBy('Time Sheets',"First_x0020_and_x0020_Last_x0020","StaffData")

This is the Filter Funtion I want nested:

Filter(StaffData, DateFilterStart <= Start_x0020_Time, DateFilterEnd >= End_x0020_Time)

How can I combine these in one string under the Items formula? Do I need to use an if function or can they just be nested? If so I would really appriciate some help with the syntax.

Thanks for your help!

[Anonymous · Accepted solution]

I managed to solve this one:

GroupBy(
    (Filter('Time Sheets', DateFilterStart <= Start_x0020_Time, DateFilterEnd >= End_x0020_Time))    
    ,"First_x0020_and_x0020_Last_x0020","StaffData")