Solved: Start Expression issue - Page 2

Shaun_Stringer · 12-05-2022 10:56 AM

I am having trouble with the filter part of my start expression.

Here is a table with example data. The table is called Training.

Employee	Training	Expiration Date
A	1	1/1/2021
B	1	2/1/2021
A	2	2/1/2021

<<Start:OrderBy(FILTER(“Training”, OR([Training]=”1”, [Training]=”2”)),[Employee], FALSE, [Expiration Date], FALSE)>>

I am trying to add to this filter expression so that if an employee has completed training 1 and training 2, as Employee A has done, AppSheet will only consider the row with the most recent Expiration Date. In this case, only the last row for Employee A.

Thank you for your help. Let me know if you need more info.

Shaun_Stringer

I got it. It is this.

<<Start:OrderBy(FILTER(“Training”, 
                     [Training Key Column] = MAXROW("Training", "Expiration Date", 
                            AND(
                                OR([Training] = "Training 1",
                                   [Training] = "Training 2"),
                            [Employee] = [_THISROW-1].[Employee]))),
        [Expiration Date], FALSE)>>
<<Employee>>

Training: <<Training>>

Expiration Date: <<[Expiration Date]>>

     <<End>>

Thank you for all of your help!

View solution in original post