Forum Discussion

JamieStrauss's avatar
JamieStrauss
Qrew Member
2 years ago

Silly Formula Question Alert

I am still learning formulas in quickbase and I wanted to write one that I thought was easy, but my brain is making it difficult.

Set Up: Advisor multi select field (field 12)
There are currently 10 Advisors
I want to hard code a formula (not use filters) to pull a report that displays only the projects the 3 out of 10 people are working on.

Am I making this to difficult because nothing works. I don't want to use the filter function because it's limited

------------------------------
Jamie Strauss
------------------------------
Formulas and functions

1 Reply

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    2 years ago
    ya, the syntax is not so intuitive

    Try this

    Includes([My List User Field],
    ToUserList(ToUser("fred@bedrock.com")))
    or
    Includes([My List User Field],
    ToUserList(ToUser("wilma@bedrock.com")))
    o
    Includes([My List User Field],
    ToUserList(ToUser("barney@bedrock.com")))

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------