Inconsistent Error with Reference

[Andrew_Ford2]

Hello Appsheet Community,

I cannot figure out why my app can read one type of related column but not another. Here is what is happening.

This formula works:
COUNT( FILTER( sfr , [siteid].[Site Name] = [_THISROW].[current yes]) )
siteid is a ref column in table sfr. It is a reference to table Caseload Builder. Table Caseload Builder has a column called Site Name. All good.

This formula gets an error:
COUNT( FILTER( sfr , [siteid].[Office] = [_THISROW].[current yes]) )
Office is a field in table Caseload Builder just the same as Site Name is. But site name works and office gets an error. I don’t understand why.

The error I get is: Error in expression ‘[siteid].[Office]’ : Unable to find column ‘Office’

I’ve tried with a few columns in Caseload Builder some work and some don’t but I can’t discern the differnece.

Thank you for any help you can provide.

[Steve · Accepted solution]

Is [siteid] a Ref to a slice that doesn’t include the Office column?

[khuslid]

My thougt exacty…

[Andrew_Ford2]

Yes! This was it. I feel silly. Thank you as always Steve.