For some reason, the results from my Row-Level Formula is not meeting the criteria.
Below is the formula:
IF(Text(MEMBER_ROLE)="Exec-Level Sponsor","Contains Exec.Sponsor","No Exec.Sponsor")
However, the results are ALL showing as False ("No Exec.Sponsor"), even though I have lines that has the value "Exec-Level Sponsor".
Does anyone know why?