IFS using Reverse Ref

Hey Everyone,

Im stuck with this.

Im trying to use this function.

IFS(
AND([Related Case Sessions][Attendance]=“Scheduled”),[Related Case Sessions][Date]<TODAY()),
“SCHEDULED”, TRUE,

I am getting the cannot compare list with text. Is this because I Should be using the IN Function? If so, how do I go about it because I’m struggling to get my head around it.

Regards
Ben

0 6 213
6 REPLIES 6
Top Labels in this Space