Problem with EXCEL template

Hi there,
When I put that expression:

<<Start: Filter(Table_name, AND(OR
([B]="STH";[B]="STH")
;[Y]=TODAY();
[Z]="Yes"
))>><<[A]>>

into the template table in R1C1 cell i get this:

<<templateReference:id=1>>

Any ideas?

I often get that result when my start expression retrieves zero results.

You can double check by creating a temporary virtual column using the start expression to see if it also produces zero results.

2 Likes

Exactly that was the reason, thanks a lot. I thought maybe there is sth wrong with my expression.

1 Like