# Conditional rollups

**URL:** <https://community.noloco.io/t/conditional-rollups/1018>\
**Category:** Feature Requests\
**Created:** [July 22, 2024, 11:02am UTC](https://community.noloco.io/t/conditional-rollups/1018 "2024-07-22T11:02:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![EthosLuke](https://avatars.discourse-cdn.com/v4/letter/e/46a35a/32.png) [@EthosLuke](https://community.noloco.io/u/EthosLuke)\
**Post date:** [July 22, 2024, 11:02am UTC](https://community.noloco.io/t/conditional-rollups/1018/1 "2024-07-22T11:02:14Z")

</div>

It would be great if we could apply conditions to filter out certain related records when using the rollup and lookup fields.

For example, I may wish to have a field which counts the amount of completed tasks in a project, if I could simply create a rollup field of tasks and filter it to only count tasks where the status is complete that would be great.

---

<div class="post-metadata">

**Author:** ![ardaergin](https://avatars.discourse-cdn.com/v4/letter/a/a88e4f/32.png) [@ardaergin](https://community.noloco.io/u/ardaergin)\
**Post date:** [September 18, 2024, 5:25pm UTC](https://community.noloco.io/t/conditional-rollups/1018/2 "2024-09-18T17:25:33Z")

</div>

Hi,

I think I found a workaround to this by adding a formula field that counts the task only if the status is completed.

So you’ll add the formula field (formula\_field) with the following formula: IF(status=“completed”, 1, 0)

And then you’ll configure the rollup to give SUM(formula\_field).

I hope it helps.

---

<div class="post-metadata">

**Author:** ![EthosLuke](https://avatars.discourse-cdn.com/v4/letter/e/46a35a/32.png) [@EthosLuke](https://community.noloco.io/u/EthosLuke)\
**Post date:** [September 18, 2024, 5:41pm UTC](https://community.noloco.io/t/conditional-rollups/1018/3 "2024-09-18T17:41:15Z")

</div>

Aha, genius! Great workaround, thank you.