Select function based on multiple criteria expression

[TKSLuke]

Hey all, been working lots with a formula suggested by this wonderful community 

Select(Dates[Time Slot] , [Level] = [_thisrow].[Level])

Everything going great, i have hit a few stumbling blocks though regarding multiple choices on the select function and wondered the best way of getting around it

Here is the data id like to select with "Time Slot" being based on event AND level selected, doable?

Thank you all

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/2347624-and

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/2347624-and

[TKSLuke]

Can you fix this for me super quick :D?

And(Select(Dates[Time Slot] ,
[Event] = [_thisrow].[Event])
And(Select(Dates[Time Slot],
[Level] = [_thisrow].[Level])))

had it semi working without the first AND but still not right

[alphacp · Accepted solution]

Select(Dates[Time Slot] , AND( [Level] = [_thisrow].[Level], [Event] = [_thisrow].[Event]))

[TKSLuke]

Literally perfect, didnt know you could use it mid formula like that, thats really cool cheers marc and alpha!