Skip to main content
Solved

SECOND-Most Recent Testing Date Formula?

  • September 21, 2021
  • 1 reply
  • 27 views

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

Best answer by Kamille_Parks11

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 reply

Kamille_Parks11
Forum|alt.badge.img+27

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