# Filtered Assignees Formula

**URL:** <https://community.fibery.io/t/filtered-assignees-formula/3034>\
**Category:** Get Help\
**Created:** [July 5, 2022, 6:10pm UTC](https://community.fibery.io/t/filtered-assignees-formula/3034 "2022-07-05T18:10:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ccollins](https://avatars.discourse-cdn.com/v4/letter/c/bbe5ce/32.png) [@ccollins](https://community.fibery.io/u/ccollins)\
**Post date:** [July 5, 2022, 6:10pm UTC](https://community.fibery.io/t/filtered-assignees-formula/3034/1 "2022-07-05T18:10:22Z")

</div>

I’m trying to create a project-level formula that shows all assignees for the project’s tasks but only for the tasks that are not yet completed. I feel like this should be possible, but am struggling to figure out how to do it. The use case is a cross project list view task board where I only want to show the project if you have an open task inside of it. Thanks in advance if anyone knows a solution.

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [July 5, 2022, 6:53pm UTC](https://community.fibery.io/t/filtered-assignees-formula/3034/2 "2022-07-05T18:53:00Z")

</div>

> [@ccollins](#):
>
> a cross project list view task board

Just for clarity, do you hope to end with a list view, a board view or something else?

---

<div class="post-metadata">

**Author:** ![ccollins](https://avatars.discourse-cdn.com/v4/letter/c/bbe5ce/32.png) [@ccollins](https://community.fibery.io/u/ccollins)\
**Post date:** [July 5, 2022, 7:00pm UTC](https://community.fibery.io/t/filtered-assignees-formula/3034/3 "2022-07-05T19:00:00Z")

</div>

List view.

Most of our task tables are project specific. But I want a ‘my task’ overview list so everyone can see only their tasks. But I don’t want the top level (project level) to show if the person viewing doesn’t have any open tasks inside of that top level.

The built in filters for assignees will filter that second level of tasks but not the top level (project level). So if employee-A once had an open item in project-A, but now does not, that project will still pop up and note urgency based on other people’s now active tasks inside that project.

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [July 5, 2022, 7:36pm UTC](https://community.fibery.io/t/filtered-assignees-formula/3034/4 "2022-07-05T19:36:41Z")

</div>

I don’t know if I am quite getting it, but have you thought of doing this:

- add a formula field to the Project database that filters only active Tasks, something like this:  
`Tasks.Filter(State.Name != "Done")`
- add a lookup on this field that gets the Assignees

Then you can create a hierarchical list and apply the necessary filters:

![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/d/d9f44a5b6dbd1dd56cecfff238dcd8eac2d2a1f3.png)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/6/6f2e9cd3dfb66fd33bdb0424b93a1cbf860f4f21.png)

Alternatively, you might want to use smart folders in a similar way…

---

<div class="post-metadata">

**Author:** ![ccollins](https://avatars.discourse-cdn.com/v4/letter/c/bbe5ce/32.png) [@ccollins](https://community.fibery.io/u/ccollins)\
**Post date:** [July 5, 2022, 7:53pm UTC](https://community.fibery.io/t/filtered-assignees-formula/3034/5 "2022-07-05T19:53:56Z")

</div>

Perfect, thank you Chris! In hindsight this is so obvious, really appreciate the help.