Help with: REF_ROWS with IFS or SELECT

Hi,

I am trying the following formula but it gets me nowhere.
What I want to achieve, is to get a list of the rows in the X data set that comply with 2 conditions.

  1. Date in Date column is equal to current Week.
  2. Name in Name column of X data set is equal to Name column in current data set.

FILTER(
“X”,
AND(
([Date] = WEEKNUM(today())),
([Name] = [_THISROW].[Name])
)
)

I also tried

(EOWEEK(TODAY()) - 6)),

Thank you in advance

[Date], is, presumably, a Date type value. WEEKNUM() outputs a Number type value. For any equality, you must compare a data type against the same data type. I suspect you want this:

WEEKNUM( [Date] ) = WEEKNUM( TODAY() )
3 Likes

Worked perfectly! Thank you very much!

2 Likes