Skip to main content
Question

Silly Formula Question Alert

  • July 14, 2022
  • 0 replies
  • 58 views
Forum|alt.badge.img+3
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • July 14, 2022
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement