Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

SECOND-Most Recent Testing Date Formula?

Topic Labels: Formulas
Solved
Jump to Solution
299 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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!!!Screen Shot 2021-09-20 at 8.46.21 PM

1 Solution

Accepted Solutions

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

See Solution in Thread

1 Reply 1

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