Help

SECOND-Most Recent Testing Date Formula?

Topic Labels: Formulas
Solved
Jump to Solution
946 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Corey_Mayne
4 - Data Explorer
4 - Data Explorer

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
Kamille_Parks
16 - Uranus
16 - Uranus

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
Kamille_Parks
16 - Uranus
16 - Uranus

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