Forum Discussion

essenceofveles's avatar
essenceofveles
Copper Contributor
May 26, 2025

Need assistance with Index Formula

I am needing help with some formulas

. My goal is to list out names of individuals who have a date listed older than 275 days (creating a 90 day warning for annual items) in a table - a series of columns.

On a different workbook, this works flawlessly.

On my new book, it doesn't work.

I've tried
=IFERROR(INDEX(Admin[Name],SMALL(IF(Admin[@[Privileging Letter Ex Date]:[HSD 500]]>(TODAY()-275),ROW(Admin[Name])),ROW(1:1))-3,1),"")

and

=FILTER(Admin[Name],Admin[[Privileging Letter Ex Date]:[HSD 500]]>TODAY()-275)

Can you help me figure out what's not working?

 

Here is a sample sheet with some dates for testing.

Here is the result. It shows the opposite of what I need, and then isn't listing them out correctly.

 

 

 

 

 

 

 

 

Here are the formulas I've tried.

It works ok on a different file - looks like below (formula shown).

Thank you.

 

1 Reply

  • Try

    =FILTER(Admin[Name], BYROW(Admin[[Privileging Letter Ex Date]:[HSD 500]], LAMBDA(r, MIN(r)))<TODAY()-275, "")

Resources