SECOND-Most Recent Testing Date Formula?

[Corey_Mayne]

Hey all! I’m stumped. I have a “Link to” column compiling every testing date, then a “Most Recent Test Date” rollup column using MAX (VALUES) to list back what the most recent date is.

However, sometimes we schedule testing dates in advance. HOW do I get a column to determine what the most recent testing date is before TODAY? Thanks so much!!!

[Kamille_Parks · Accepted solution]

Turn on the “Only include linked records from the [Table Name] table that meet certain conditions” toggle in your rollup field, set the condition to be Date is before today