Formula Query Question HAS/CT
@Quick Base Junkie gives an amazing tutorial on Formula Queries. Also, previously in the community explained HAS vs CT (contains). The difference being, HAS looks at a multi select text and must match...
Forum Discussion
Hi Mike,
The HAS intended use-case is for list-user fields, I pasted the documentation below:
------------------------------
Sean Connaughton
------------------------------
The HAS intended use-case is for list-user fields, I pasted the documentation below:
| COMPARISON OPERATOR | DESCRIPTION |
|---|---|
|
CT |
Contains (Do not use this operator with list-user fields; instead, use HAS.) |
|
HAS |
------------------------------------------------------------------------------------------------ For each user you are trying to find, you must enter the user's ID, user name, or email address. You can also enter placeholder names. Be sure to surround placeholder names with double quotes. The query parameter must be surrounded by single quotes. Separate users in the list using a semi-colon. For example:
|
------------------------------
Sean Connaughton
------------------------------