Advanced formula environment: Trimrange operator Syntax Error

The trimrange operator is not recognised by the Advanced formula environment. It is marked as a syntax error which is incorrect. 

<img width="464" height="377" alt="Image" src="https://github.com/user-attachments/assets/965b873b-e19a-41b3-878a-ce44b5c59520" />