# RACI MATRIX Space Idea

**URL:** <https://community.fibery.io/t/raci-matrix-space-idea/5034>\
**Category:** Get Help\
**Created:** [August 29, 2023, 4:25pm UTC](https://community.fibery.io/t/raci-matrix-space-idea/5034 "2023-08-29T16:25:15Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![gasserol](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gasserol/32/7358_2.png) [@gasserol](https://community.fibery.io/u/gasserol)\
**Post date:** [August 29, 2023, 4:25pm UTC](https://community.fibery.io/t/raci-matrix-space-idea/5034/1 "2023-08-29T16:25:15Z")

</div>

How can I best build a matrix like the one in the image? I can create the four databases Sector, Activities, Roles and RACI, but I do not find a way of creating a view, where Sector and Activities are shown and then for each Role we have a column, where we can add the RACI relation.

 ![Bildschirmfoto 2023-08-29 um 18.22.33](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/23e1d32e3e7618a1cb3bb1e564d4c85157c91973.png)

I started with the new Grid View. I have the following Relations at the moment: Sector can have multiple Activities, Roles can have multple RACI (Responsible, Accountable, Consulted, Informed).

Does anyone have an idea how I could build such a view? then publish the space as a template for all?

---

<div class="post-metadata">

**Author:** ![Yuri\_BC](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yuri_bc/32/8803_2.png) [@Yuri\_BC](https://community.fibery.io/u/Yuri_BC)\
**Post date:** [August 30, 2023, 6:01am UTC](https://community.fibery.io/t/raci-matrix-space-idea/5034/2 "2023-08-30T06:01:00Z")

</div>

Such an RACI Matrix will be much more easy with the upcoming new relationship entity that the fibery team currently is working on ([References Reloaded](https://community.fibery.io/t/references-reloaded/4879)), because now we are still working with read-only lookup fields. This now means that if you create lookup fields for each RACI database item related to a user, you cannot edit the values in the table.

Here is a workaround:

Create an ‘RACI entry’, ‘Sector’, ‘Activity’ databases.  
In the RACI entry database, create relation fields to Sector and Activity, plus as many multi-select fields as you have team members. The multi-select fields all have the same options (R, A, C, I)  
Name=formula=entity ID, or a custom code you use for the responsibility.

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

---

<div class="post-metadata">

**Author:** ![gasserol](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/gasserol/32/7358_2.png) [@gasserol](https://community.fibery.io/u/gasserol)\
**Post date:** [August 30, 2023, 7:33am UTC](https://community.fibery.io/t/raci-matrix-space-idea/5034/3 "2023-08-30T07:33:26Z")

</div>

> [@Yuri\_BC](#):
>
> References Reloaded

Thanks @Yuri_BC I will try this out!

---

<div class="post-metadata">

**Author:** ![Yuri\_BC](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yuri_bc/32/8803_2.png) [@Yuri\_BC](https://community.fibery.io/u/Yuri_BC)\
**Post date:** [August 30, 2023, 10:20am UTC](https://community.fibery.io/t/raci-matrix-space-idea/5034/4 "2023-08-30T10:20:13Z")

</div>

Using a Board it is possible without the need to created dedicated member fields like above, but using a ‘Responsability Assignment’ entity that has a single Activity field, single member relationship and a multi select field RACI. It allows to display more helpful fields in the assignment entity cards where needed.  
Columns = member  
Rows = Activity

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

---

<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:** [August 30, 2023, 10:23am UTC](https://community.fibery.io/t/raci-matrix-space-idea/5034/5 "2023-08-30T10:23:15Z")

</div>

> [@gasserol](#):
>
> How can I best build a matrix like the one in the image?

Do you need the view to be editable?  
If not, a report view will probably be the closest resemblance to the image you shared.  
And it has an advantage of being easily shareable via URL
