Can a formula know the filters being used?

I have built a Risk Matrix in HTML. It’s a formula in the Risks table. The HTML widget shows it.

But I am not able to find a way to show only the fields that are being filtered in the table. It shows all Risks in the table. If I filter the table by a department for example, it won´t reflect in the Risk Matrix, because the formula in the Risks table doesn´t “know” the table is being filtered by Departments.

1 Like