Forum Discussion
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, "")