SECOND-Most Recent Testing Date Formula?

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!!!

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

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.