Hi Michael,
The function User() returns the current user.
But Quick Base does not like comparing apples to oranges in a report filter and to Quick Base, a field of type List User cannot be compared with a field of type User in a report filter. So if the report does not natively offer up to company to "the current user", then a work around is to create a List User formula field which just has the current user in it, ie just 1 user ecven though it is a List User field type.
So to make that field we use
ToUserlist (User())
and call it like [Current User in List User format]
Then the report will be filtered where
[Project Managers] include the value in the field [Current User in List User format]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
