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?
2 replies
-
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
-
I just tried this again today and now it is working. I'm not sure what I did wrong before.
Content aside
- 4 yrs agoLast active
- 2Replies
- 689Views