I have a table with TV series, season, episodes, titles, and whether watched or not. I would like to write a filter that gives me the 1st not watched episode in a series. I have tried:TOP(FILTER(Shows,[Watched] <> true),1)and get the error The expres...

I need a conditional formatting statement that will indicate a that a deadline passed using time values. I have a field named [finish] which contains date and time values.I have tried time(need[finish]) < timenow()