0

Filtering a formula column results in empty display

I have a table with a "Assigned To" field of type User. I would like to filter my view to show records for the current user only. I created a new formula field in my view called AssignedToCurrentUser. My forumula is:

text('Assigned To') = userName()

I see "Yes" and "No" as expected in the column. I click the AssignedToCurrentUser column, click filter and I am prompted with a Yes/No popup. I select "Yes" and then all rows disappear from my view.

Is it possible to filter a view by filtering a forumula field in the view?

3 replies

null
    • Tapcast, Inc.
    • Kevin_Lindsey
    • 5 yrs ago
    • Reported - view

    I should mention that my original approach was to filter "Assigned To" directly, but using somethign like "=userName()" kept giving me an error about an unexpected value after '='. This is why I tried the approach above

    • Tapcast, Inc.
    • Kevin_Lindsey
    • 5 yrs ago
    • Reported - view

    I just tried this again today and now it is working. I'm not sure what I did wrong before.

    • Jarno_Vande_Walle
    • yesterday
    • Reported - view

    HI Kevin, I experienced a similar problem; Turned out that this happens when you use many select statements and there is a lot of data. If you can remove the select statements, this problem does not occur anymore.

Login to reply

Content aside

  • yesterdayLast active
  • 3Replies
  • 705Views
  • 1 Following